Trumping the PostgreSQL Query Planner This is an off-site link.  Please review our Terms of Service for additional information.

(Shaun M. Thomas) With the release of PostgreSQL 8.4, the community gained the ability to use CTE syntax. As such, this is a fairly old feature, yet it’s still misunderstood in a lot of ways. At the same time, the query planner has been advancing incrementally since that time. Most recently, PostgreSQL has gained the ability to perform index-only scans, making it possible to fetch results straight from the index, without confirming rows with the table data.

Read this article...

comments powered by Disqus