Received: from localhost (maia-4.hub.org [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id E29D29FA3E9
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  4 Apr 2007 03:33:04 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 92223-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  4 Apr 2007 03:32:57 -0300 (ADT)
X-Greylist: delayed 00:25:26.333013 by SQLgrey-1.7.4
Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159])
	by postgresql.org (Postfix) with ESMTP id ABDCF9FBA3B
	for <pgsql-performance@postgresql.org>;
	Wed,  4 Apr 2007 03:32:56 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3
Received: from mail3.plesk.ru (gw-swsoft2.ll-nsk.zsttk.ru [82.200.65.190])
	by svr4.postgresql.org (Postfix) with ESMTP id 96CC85AF8A0
	for <pgsql-performance@postgresql.org>;
	Wed,  4 Apr 2007 06:07:28 +0000 (GMT)
Received: by mail3.plesk.ru (Postfix, from userid 426)
	id 809931A9C0F; Wed,  4 Apr 2007 13:07:24 +0700 (NOVST)
Received: from [192.168.62.36] (Ogurtsov.plesk.ru [192.168.62.36])
	by mail3.plesk.ru (Postfix) with ESMTP id 589551A9C09
	for <pgsql-performance@postgresql.org>;
	Wed,  4 Apr 2007 13:07:24 +0700 (NOVST)
Message-ID: <46134098.9050301@swsoft.com>
Date: Wed, 04 Apr 2007 13:07:20 +0700
From: Eugene Ogurtsov <eogurtsov@swsoft.com>
Organization: SWsoft
User-Agent: Thunderbird 1.5.0.10 (Windows/20070221)
MIME-Version: 1.0
To: postgres performance list <pgsql-performance@postgresql.org>
Subject: postgresql.conf file for PostgreSQL 8.2.3
References: <HCEPKPMCAJLDGJIBCLGHOEKOHGAA.james@mansionfamily.plus.com>
In-Reply-To: <HCEPKPMCAJLDGJIBCLGHOEKOHGAA.james@mansionfamily.plus.com>
Content-Type: multipart/alternative;
	boundary="------------000906070600060200020003"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.725 tagged_above=0 required=5 tests=BAYES_50=0.001,
	FORGED_RCVD_HELO=0.135, HTML_30_40=0.374, HTML_MESSAGE=0.001,
	HTML_TITLE_EMPTY=0.214
X-Spam-Level: 
X-Archive-Number: 200704/51
X-Sequence-Number: 23928

This is a multi-part message in MIME format.
--------------000906070600060200020003
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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.


--------------000906070600060200020003
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Please help me to set up optimal values in the postgresql.conf file for
PostgreSQL 8.2.3<br>
<br>
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:<br>
<ol>
  <li>DB size: 25-30Gb</li>
  <li>number of tables: 100 - 150</li>
  <li>maximum number of records for one table: 50 - 100 millions</li>
  <li>avarage number of records for one table: 3 - 5 millions</li>
  <li>DB's querying frequency: 150-500 per minute</li>
  <li>SELECT/INSERT/UPDATE correlation is equal</li>
  <li>DELETE operations are performed rarely<br>
  </li>
</ol>
<br>
Server Hardware:<br>
<ul>
  <li>2x Xeon 2.8Ghz</li>
  <li>6GB RAM (2 GB for OS and DB, 4GB for Application)</li>
  <li>RAID-10 w/ 6x72GB 15.000rpm HDDs</li>
</ul>
<br>
<br>
<pre class="moz-signature" cols="72">-- 
Thanks,

Eugene Ogurtsov
Internal Development Chief Architect
SWsoft, Inc.</pre>
</body>
</html>

--------------000906070600060200020003--