mmiranda(at)americatel(dot)com(dot)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