/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

 hakibenita.com
Unconventional PostgreSQL Optimizations | Haki Benita
| | use-the-index-luke.com
Index INCLUDE Clause: How it works and when to use it
5.2 parsecs away

Travel
| | The INCLUDE clause for CREATE INDEX is available in some SQL databases: Microsoft SQL Server, PostgreSQL, and IBM Db2 (LUW)
| | boringsql.com
Reading Buffer statistics in EXPLAIN output | boringSQL
4.9 parsecs away

Travel
| | Learn how to interpret buffer statistics in PostgreSQL EXPLAIN output. Understand shared hits, disk reads, temp spills, and planning buffers to accurately diagnose and fix query performance bottlenecks.
| | www.rorvswild.com
Speed Up Compound Full-Text Searches in PostgreSQL by 300x - RoRvsWild
4.8 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.
| | www.depesz.com
Waiting for 9.1 - Faster LIKE/ILIKE - select * from depesz;
23.5 parsecs away

Travel
| [AI summary] This post details a PostgreSQL patch introducing faster LIKE and ILIKE index searches using pg_trgm, demonstrating significant performance improvements over sequential scans while discussing the trade-off with increased indexing and maintenance times.