From: Eugene Ogurtsov <eogurtsov@swsoft.com>
To: postgres performance list <pgsql-performance@postgresql.org>
Subject: postgresql.conf file for PostgreSQL 8.2.3
Date: Wed, 04 Apr 2007 13:07:20 +0700
Message-ID: <46134098.9050301@swsoft.com> (raw)
In-Reply-To: <HCEPKPMCAJLDGJIBCLGHOEKOHGAA.james@mansionfamily.plus.com>
References: <HCEPKPMCAJLDGJIBCLGHOEKOHGAA.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:
1. DB size: 25-30Gb
2. number of tables: 100 - 150
3. maximum number of records for one table: 50 - 100 millions
4. avarage number of records for one table: 3 - 5 millions
5. DB's querying frequency: 150-500 per minute
6. SELECT/INSERT/UPDATE correlation is equal
7. 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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: eogurtsov@swsoft.com
Subject: Re: postgresql.conf file for PostgreSQL 8.2.3
In-Reply-To: <46134098.9050301@swsoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox