Re: Indexen on 8.0.3 - Mailing list pgsql-general

From Tom Lane
Subject Re: Indexen on 8.0.3
Date
Msg-id 20837.1128615602@sss.pgh.pa.us
Whole thread Raw
In response to Indexen on 8.0.3  (han.holl@informationslogik.nl)
Responses Re: Indexen on 8.0.3
Re: Indexen on 8.0.3
List pgsql-general
han.holl@informationslogik.nl writes:
> After upgrading to 8.0.3 I see very poor performance on several indexes.
> ...
> Database was recently analyzed. Clearly, something has to be tuned that didn't
> need tuning on 7.4.3 ? (Main table has about 1.7 million records).

No, there's no reason for 8.0 to be slower at this than 7.4, if all else
is equal.  I'm betting that all else is not equal.  Maybe you are using
a different encoding or locale in the new installation than the old?

            regards, tom lane

pgsql-general by date:

Previous
From: Jeff MacDonald
Date:
Subject: Re: a bug, now(), default CURRENT_TIME, WAL Logs.
Next
From: "Jim C. Nasby"
Date:
Subject: Re: PostgreSQL 8.1 vs. MySQL 5.0?