Re: Using Explain - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Using Explain
Date
Msg-id 3330.994349451@sss.pgh.pa.us
Whole thread Raw
In response to Using Explain  ("P. Dwayne Miller" <dmiller@espgroup.net>)
List pgsql-hackers
"P. Dwayne Miller" <dmiller@espgroup.net> writes:
> Any places to look that might explain the results of explain?

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

If you're still confused, feel free to post the query, table schemas,
and EXPLAIN output.

BTW, have you run VACUUM ANALYZE?  If not, you're unlikely to get a
good plan.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Naomi Walker
Date:
Subject: Re: Re: Backup and Recovery
Next
From: Bruce Momjian
Date:
Subject: Re: AW: Re: Backup and Recovery