Re: [PERFORM] : PostgreSQL Index behavior

2012-09-12 Thread Scott Marlowe
On Wed, Sep 12, 2012 at 12:57 AM, Venkat Balaji wrote: > We are using PostgreSQL-9.0.1. You are missing almost 2 years of updates, bug fixes, and security fixes. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.post

[PERFORM] Guide to Posting Slow Query Questions

2012-09-12 Thread Jeff Janes
Regarding the wiki page on reporting slow queries: https://wiki.postgresql.org/wiki/Slow_Query_Questions We currently recommend EXPLAIN ANALYZE over just EXPLAIN. Should we recommend EXPLAIN (ANALYZE, BUFFERS) instead? I know I very often wish I could see that data. I don't think turning buff