Basic Query Tuning Primer

Matt Smiley

From PostgreSQL Conference West Speakers

This is a basic primer aimed primarily at developers or DBAs new to Postgres. The format is a Q/A style tour with examples, based on common questions and pitfalls. Begin with a quick tour of relevant parts of the postgres catalog, with an aim to answer simple but important questions like:

How many rows does the optimizer think my table has?
When was it last analyzed?
Which other tables also have a column named "foo"?
How often is this index used?
pg west 2009 - basic query tuning primer.odp42.66 KB