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@outtalimits.com.au
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
No comments:
Post a Comment