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@xxxxxxxxxxxxxxxxxx
