Re: the eternal tunnig question - Mailing list pgsql-general

From Tom Lane
Subject Re: the eternal tunnig question
Date
Msg-id 27871.1114833034@sss.pgh.pa.us
Whole thread Raw
In response to the eternal tunnig question  (mmiranda@americatel.com.sv)
List pgsql-general
mmiranda@americatel.com.sv writes:
> Hi, iam running postgresql on two identical dl380 2.4 Xeon with 3gb RAM, i
> have recently upgraded one of then from redhat 7.3 (kernel 2.4) to gentoo
> (kernel 2.6), at the same time i upgraded postgres from 7.3 to 8.1, im very
> disapointed, all the querys are 20-25% slower using the new versions, the
> following setting are the same in postgresql.conf

You might have forgotten to redo vacuum/analyze after reloading your
data ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fatal error
Next
From: Tom Lane
Date:
Subject: Re: Tuning queries inside a function