Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3

From: Christof Petig <christof(at)petig-baender(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Query Planning time increased 3 times on 7.1 compared to 7.0.3
Date: 2001-03-07 15:08:47
Message-ID: 3AA64EFF.EA49902A@petig-baender.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:

> Christof Petig <christof(dot)petig(at)wtal(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Olivier PRENANT 2001-03-07 15:17:09 Re: Contributions?
Previous Message Bruce Momjian 2001-03-07 14:59:55 Re: WAL & SHM principles