🔍 Query Optimization - emschwartz · Scour

How Do LLM Agents Think Through SQL Join Orders? 🎯Query Optimizer

ucbskyadrs.github.io·6d·Hacker News

ExaBench: An Open Database Performance Leaderboard ⚡Systems Performance

exasol.com·1d·Hacker News

On pgvectorscale, and Hybrid Search Without an Elasticsearch Sidecar 🐘pgvector

thebuild.com·7h

What ORMs have taught me: just learn SQL (2014) 💾Databases

wozniak.ca·7h·Hacker News

R$^3$-SQL: Ranking Reward and Resampling for Text-to-SQL 🐘pgvector

Advanced PostgreSQL: JSONB, partial indexes and partitioning 🌲GIN Indexes

web-developpeur.com·5d·DEV

The Best (Query) Plans of Mice and Men 💾Databases

ohadravid.github.io·2d·Lobsters, Hacker News

Announcing Functional Indexes in Dolt 🌲GIN Indexes

dolthub.com·2d

Nimble Cluster Index: Efficient Indexed Lookups on Columnar Data 🌲GIN Indexes

velox-lib.io·4d

PostgreSQL is Not Slow. Your Queries Are. 🐘PostgreSQL

stormatics.tech·1d·Hacker News

Rethinking SQL ETL for modern data platforms 📦In-process Databases

databricks.com·1d

Why PostgreSQL EXPLAIN ANALYZE Can Mislead You 🔍EXPLAIN ANALYZE

kargin-utkin.com·5d·DEV

HOT Updates in Postgres 🐘PostgreSQL

boringsql.com·2d·Hacker News

Where Optimizations Come From ⚙Rust Compiler Internals

NULL BITMAP by Justin Jaffray via buttondown.com·3d·Hacker News

Query plan regressions got you down? Here's how can Automatic Plan Correction turns it around. ⚡SQL Optimization

techcommunity.microsoft.com·2d

The Monday Elephant #2: SQL Queries to List Users and Groups 🐘PostgreSQL

pgdash.io·3d·r/PostgreSQL

SEMA-SQL: Beyond Traditional Relational Querying with Large Language Models 🔄LLM RAG Pipelines

arxiv.org·3d·Hacker News

PExA: Parallel Exploration Agent for Complex Text-to-SQL ⚡Vectorized Execution

MCI: A Maximal Clique Index for Efficient Arbitrary-Filtered Approximate Nearest Neighbor Search 🔍Vector Search Algorithms

Dynamic Grammar-Compressed Self-Index in $delta$-Optimal Space 🗂️Vector Indexes

Log in to enable infinite scrolling