Tom Lane wrote:
> [EMAIL PROTECTED] 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'
On 10/6/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> On Thursday 06 October 2005 18:20, Tom Lane wrote:
> >
> > 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 loca
On Thursday 06 October 2005 18:20, Tom Lane wrote:
>
> 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?
>
Well, I suspect that som
[EMAIL PROTECTED] 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 s
Hi,
After upgrading to 8.0.3 I see very poor performance on several indexes.
Like this: (udps is a view on main)
palga=> explain analyze select rapnaam from udps where naamvrouw like 'vos%';
QUERY PLAN
-
