Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL 7.4 runs slower than 7.3 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostgreSQL 7.4 runs slower than 7.3
Date
Msg-id 945.1095778833@sss.pgh.pa.us
Whole thread Raw
In response to PostgreSQL 7.4 runs slower than 7.3  ("D'Arcy J.M. Cain" <darcy@druid.net>)
Responses Re: PostgreSQL 7.4 runs slower than 7.3  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-hackers
Tree view 
"D'Arcy J.M. Cain" <darcy@druid.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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Disabling bgwriter on my notebook
Next
From: Laszlo Hornyak
Date:
Subject: Re: psql: FATAL: Password authentication failed for