How to optimize PostgreSQL for a 16GB RAM Quad-Core machine?
Posted on 2007-07-23
I would like to optimize postgres for the best possible performance for a single query. I am not going to use it in a multi-user environment, but performance of a single query is most important.
Could someone suggest correct config settings for PostgreSQL 8.2 for the following hardware:
Dell PowerEdge 2900, 1 Xeon 2.6GHz Quad-Core processor, 16GB memory, 4 RAID0 15000RPM SAS hard-disks, Windows 2003 R2 64Bit Server Edition (default configuration).
When I just use the default config file, I have a feeling postgres is not even using a 0.1% of the given resources, especially in terms of memory.