🔍 Query Optimization - emschwartz · Scour

Index-Assisted Stratified Sampling for Online Aggregation 🌲GIN Indexes

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

web-developpeur.com·5d·DEV

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

thebuild.com·9h

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

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

wozniak.ca·9h·Hacker News

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

ExaBench: An Open Database Performance Leaderboard ⚡Systems Performance

exasol.com·1d·Hacker News

Why PostgreSQL EXPLAIN ANALYZE Can Mislead You 🔍EXPLAIN ANALYZE

kargin-utkin.com·5d·DEV

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

databricks.com·1d

Where Optimizations Come From ⚙Rust Compiler Internals

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

HOT Updates in Postgres 🐘PostgreSQL

boringsql.com·2d·Hacker News

SynSQL: Synthesizing Relational Databases for Robust Evaluation of Text-to-SQL Systems 🔄SQL Transpilation

Efficient Multivector Retrieval with Token-Aware Clustering and Hierarchical Indexing 🔍Vector Search Algorithms

Reliable Answers for Recurring Questions: Boosting Text-to-SQL Accuracy with Template Constrained Decoding 🔄SQL Transpilation

Agent-Agnostic Evaluation of SQL Accuracy in Production Text-to-SQL Systems 🔄SQL Transpilation

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

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

Log in to enable infinite scrolling