Peter Geoghegan's blog

Musings on PostgreSQL, database technology in general, and software development

Tuesday, December 4, 2012

Finding plans in pg_stat_plans easily with pg_find_plans

As I recently blogged about , pg_stat_plans is a PostgreSQL satellite project I've been working on that aims to support earlier versio...

Friday, November 16, 2012

Notes on index-only scans

One of the most important performance features in Postgres 9.2 is index-only scans: the ability for certain types of queries to be performed...

Saturday, October 20, 2012

First release of pg_stat_plans

Anyone who attended my recent talk at Postgres Open , which was co-presented with my 2ndQuadrant colleague Greg Smith, "Beyond Query Lo...

Wednesday, August 1, 2012

Sorting improvements in PostgreSQL 9.2: the case for micro-optimisation

There has been much discussion of performance improvements in the upcoming 9.2 release of PostgreSQL. Recently, I noticed that Regina Obe an...

View web version

About Me

Peter Geoghegan: I'm a PostgreSQL Major Contributor and Committer.

Twitter: @petervgeoghegan

View my complete profile

Powered by Blogger.