Recourse Usage

G'day,

I have been tasked to tune our company's Postgres database. From the

research I have done I feel the recourse consumption parameters are set far

to low. I have come up with the following modifications to the

configuration and wanted to run this by the mailing list for any

suggestions. The database is on a semi dedicated box, shared only with

memcached which has been allocated 512MB.

-Dual Xeon 2.33GHz

-4GB RAM

-Twin SAS drives in RAID 1

Shared Buffers

Currently: 8192 pages @ 8 KB each // 64MB

To be set to: (256MB - 32768 pages @ 8 KB each)

Work Mem

Currently: 1024kb

To be set to: 1536kb

Effective Cache Size

Currently: 50000 pages // 390MB

To be set to: 128000 pages // 1000MB

Random Page Cost

Currently: 4.0

To be set to: 3.0

Wal Buffers

Currently: 8 @ 8kb each

To be set to: 32 @ 8kb each

Kind Regards,

--

-------------------------------------------------

Steve Kecskes

steve(at)outtalimits(dot)com(dot)au