Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group