/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 abuisman.com
Simple query optimisation | ABuisman.com
| | www.sagargv.com
How to read a query plan from Postgres EXPLAIN
2.1 parsecs away

Travel
| |
| | newvick.com
Why understanding B-trees will help you improve database performance Newvick's blog
2.0 parsecs away

Travel
| | b-trees database indexes partial index function-based index multi-column index
| | akorotkov.github.io
Faceted Search in the Single PostgreSQL Query - Alexander Korotkov's blog
1.5 parsecs away

Travel
| | [AI summary] A technical article demonstrates how to implement efficient faceted search for mailing list archives using a single PostgreSQL SQL query with window functions and CTEs.
| | www.rorvswild.com
Speed Up Compound Full-Text Searches in PostgreSQL by 300x - RoRvsWild
9.7 parsecs away

Travel
| Querying your database across associations can become a bottleneck in your Rails application. Julian Rubisch, our first guest author, explains why and suggests an efficient solution.