the eternal tunnig question - Mailing list pgsql-general

From mmiranda@americatel.com.sv
Subject the eternal tunnig question
Date
Msg-id 76E0DAA32C39D711B6EC0002B364A6FA0445C429@amsal01exc01.americatel.com.sv
Whole thread Raw
Responses Re: the eternal tunnig question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Keatis"
Date:
Subject: Re: Problem: message type 0xxx arrived from server while idle
Next
From: Tony Caduto
Date:
Subject: Re: Tuning queries inside a function