Re: Learning to read explain - Mailing list pgsql-novice

From Tom Lane
Subject Re: Learning to read explain
Date
Msg-id 11832.1007162161@sss.pgh.pa.us
Whole thread Raw
In response to Re: Learning to read explain  (Francisco Reyes <lists@natserv.com>)
List pgsql-novice
Francisco Reyes <lists@natserv.com> writes:
> It seems a common issue for newbies, yet I don't see any docs on the
> subject. Maybe there are, I just don't know where they are.

http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/performance-tips.html

There is a slightly improved (IMHO) writeup in the 7.2 docs,
http://candle.pha.pa.us/main/writings/pgsql/sgml/performance-tips.html
but this also talks about features like EXPLAIN ANALYZE that don't
exist in 7.1 ...

            regards, tom lane

pgsql-novice by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Learning to read explain
Next
From: Ken Corey
Date:
Subject: Disk space problem...