Thread

1. HackerThemAll · 1789635117 · focus · HN ↗

   Two things. One is that to remind folks that PostgreSQL has used a tiny form of "artificial intelligence", that is GEQO - Genetic Query Optimizer, since 2001.

   Second. How would that LLM-based query optimizer work in a real-world 10,000 qps ERP system with very large shape of queries? I'm not saying it's useless, it just won't replace a real query planner soon. Latencies would skyrocket.

   1. karambahh · 1789638652 · focus · HN ↗

      I'm also quite skeptical of performance/determinism over a real world load but if I'm not mistaken, a 10 000 qps with large shape of queries would not benefit much either from genetic algos, would it?

      1. HackerThemAll · 1789715004 · focus · HN ↗

         I've seen this kind of performance coming out of PostgreSQL, so they do help somehow.

Unofficial Hacker News client; not affiliated with Y Combinator.