postgresql.conf file for PostgreSQL 8.2.3
От
Eugene Ogurtsov
Тема
postgresql.conf file for PostgreSQL 8.2.3
Дата
Msg-id
46134098.9050301@swsoft.com
Ответ на
Re: compact flash disks? (James Mansion)
Список
Дерево обсуждения
compact flash disks? "James Mansion" <james@mansionfamily.plus.com>
Re: compact flash disks? cedric <cedric@over-blog.com>
Re: compact flash disks? Florian Weimer <fweimer@bfk.de>
Re: compact flash disks? "Merlin Moncure" <mmoncure@gmail.com>
Re: compact flash disks? Ron <rjpeace@earthlink.net>
Re: compact flash disks? Carlos Moreno <moreno_pg@mochima.com>
Re: compact flash disks? Csaba Nagy <nagy@ecircle-ag.com>
Re: compact flash disks? "James Mansion" <james@mansionfamily.plus.com>
postgresql.conf file for PostgreSQL 8.2.3 Eugene Ogurtsov <eogurtsov@swsoft.com>
Re: compact flash disks? "James Mansion" <james@mansionfamily.plus.com>
Re: compact flash disks? Magnus Hagander <magnus@hagander.net>
Re: compact flash disks? "Merlin Moncure" <mmoncure@gmail.com>
Re: compact flash disks? "James Mansion" <james@mansionfamily.plus.com>
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:
Server Hardware:
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.
В списке pgsql-performance по дате отправления
От: Peter Schuller
Дата:
