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 @[EMAIL PROTECTED]
8 KB each // 64MB
To be set to: (256MB - 32768 pages @[EMAIL PROTECTED]
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 @[EMAIL PROTECTED]
8kb each
To be set to: 32 @[EMAIL PROTECTED]
8kb each
Kind Regards,
--
-------------------------------------------------
Steve Kecskes
steve@[EMAIL PROTECTED]
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
