Please help me to set up optimal values in the postgresql.conf file for PostgreSQL 8.2.3
Can you please give us an advice, which of your DBs and which configuration should we take for a project that has the following parameters:
- DB size: 25-30Gb
- number of tables: 100 - 150
- maximum number of records for one table: 50 - 100 millions
- avarage number of records for one table: 3 - 5 millions
- DB's querying frequency: 150-500 per minute
- SELECT/INSERT/UPDATE correlation is equal
- DELETE operations are performed rarely
Server Hardware:
- 2x Xeon 2.8Ghz
- 6GB RAM (2 GB for OS and DB, 4GB for Application)
- RAID-10 w/ 6x72GB 15.000rpm HDDs
--
Thanks,
Eugene Ogurtsov
Internal Development Chief Architect
SWsoft, Inc.