PostgreSQL configuration (work_mem, effective_cache_size etc.)
- by JohnHawkins
:)
I know I can base on tutorials that I can find on net, but there are confusing, and I know there are some of Postgres gurus here.
My hardware:
2x Intel Xeon E5645 2,40 GHz / 32 GB of RAM / 2xSAS for pg_xlog (RAID1) + 3x2 SAS for rest (RAID10) + BBU and 512 MB of cache.
It's gonna be used for one web project, with some big (relative term :P) tables (20mil+ of records).
Server is dedicated to Posgtres service. I need help with configuring it - work_mem, effective_cache_size etc.