Postgres Pro
Downloads
Home   >   mailing lists

Re: different query plan for same select - Mailing list pgsql-performance

From Tom Lane
Subject Re: different query plan for same select
Date
Msg-id 13276.1058973666@sss.pgh.pa.us
Whole thread Raw
In response to different query plan for same select  (Jörg Schulz <jschulz@sgbs.de>)
Responses Re: different query plan for same select  (Jörg Schulz <jschulz@sgbs.de>)
List pgsql-performance
Tree view 
=?iso-8859-1?q?J=F6rg=20Schulz?= <jschulz@sgbs.de> writes:
> I'm not very familar with the output of the explain command but can you
> tell me why I get two different query plans?

Judging from the suspiciously round numbers in the cost estimates,
you've never done a VACUUM ANALYZE on any of these tables.  Try that and
then see what plans you get...

            regards, tom lane

pgsql-performance by date:

Previous
From: Jörg Schulz
Date:
Subject: different query plan for same select
Next
From: Tom Lane
Date:
Subject: Re: factoring problem with view in 7.3.3