Re: different query plan for same select

From: Jörg Schulz <jschulz(at)sgbs(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: different query plan for same select
Date: 2003-07-24 06:06:22
Message-ID: 200307240806.22941.jschulz@sgbs.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> > 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...

Oops.. You were right!

Thank you anyway.

Jörg

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar 2003-07-24 13:09:26 Re: hardware performance and some more
Previous Message Guthrie, Jeremy 2003-07-23 18:38:03 Re: slow table updates