Postgres Pro
Downloads
Home   >   mailing lists

Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3 - Mailing list pgsql-hackers

From Christof Petig
Subject Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3
Date
Msg-id 3AA64EFF.EA49902A@petig-baender.de
Whole thread Raw
In response to Query Planning time increased 3 times on 7.1 compared to 7.0.3  (Christof Petig <christof.petig@wtal.de>)
List pgsql-hackers
Tree view 
Tom Lane wrote:

> Christof Petig <christof.petig@wtal.de> writes:
> > We noticed that after upgrading to 7.1beta[245] the execution time for
> > some often used queries went up by a factor of 2 or more.
>
> I get the desired plan after doing VACUUM ANALYZE ...
>
>                         regards, tom lane

I apologize. I must have been smoking something when I did the vacuum
analyze. And my nightly script did not work. 7.1 is much faster.

Christof

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: WAL & SHM principles
Next
From: Olivier PRENANT
Date:
Subject: Re: Contributions?