the eternal tunnig question
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
shared_buffers = 10240
work_mem = 5120
max_fsm_pages = 170000
max_fsm_relations = 10000
i havent touched anything else.
However i see a lot of new setting in PG8, is there a online manual for
tunnig these new settings?, may be a need some fine setting here and there.
thanks
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
Tom Lane wrote:
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.confYou might have forgotten to redo vacuum/analyze after reloading your
data ...regards, tom lane
thanks Tom,
Definitely you're the man around here, vacuum/analyze did the trick
BTW, i found this very interresting link, answered my questions about
tunning,
http://www.varlena.com/varlena/GeneralBits/Tidbits/#performance
bye
---
Import Notes
Resolved by subject fallback