Re: PostgreSQL 7.4 runs slower than 7.3

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "D'Arcy J(dot)M(dot) Cain" <darcy(at)druid(dot)net>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: PostgreSQL 7.4 runs slower than 7.3
Date: 2004-09-21 15:00:33
Message-ID: 945.1095778833@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

"D'Arcy J.M. Cain" <darcy(at)druid(dot)net> writes:
> I had previously mentioned that queries run much different depending on
> whether a VACUUM ANALYZE is done or just a plain ANALYZE.

The problem appears to be that it's picking the wrong index to use for
the second part of the query (the certrans_active = 'f' part). You have
not shown us enough info to guess why though.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Laszlo Hornyak 2004-09-21 15:04:03 Re: psql: FATAL: Password authentication failed for
Previous Message Bruce Momjian 2004-09-21 14:22:57 Re: Disabling bgwriter on my notebook