References: <1402507690.19836.YahooMailNeo@web122306.mail.ne1.yahoo.com>
 <26995497.123.1402508346235.JavaMail.lenovo@lenovo-PC>
Message-ID: <1402508911.42015.YahooMailNeo@web122301.mail.ne1.yahoo.com>
Date: Wed, 11 Jun 2014 10:48:31 -0700 (PDT)
From: Kevin Grittner <kgrittn@ymail.com>
Reply-To: Kevin Grittner <kgrittn@ymail.com>
Subject: Re: PostgreSQL db
To: Amit Sharma <asharma@verts.co.in>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
In-Reply-To: <26995497.123.1402508346235.JavaMail.lenovo@lenovo-PC>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Amit Sharma <asharma@verts.co.in> wrote:
> "Kevin Grittner" <kgrittn@ymail.com> wrote:

>> Personally, I managed a machine which typically had 3000 users
>> running queries against it while about 20 million
>> INSERT/UPDATE/DELETE statements per day were run against it.
>> Tuning showed best performance when we used connection pools
>> with 35 connections for read-only queries and 6 connections for
>> the DML.

> May I know the machine configuration esp. the hardware
> configuration that you used for this setup?

It had 16 cores and 256GB RAM, a RAID controller with 256MB
battery-backed RAM configured for write-back for a 40 drive RAID 5
array, with a separate BBU controller for a RAID 1 pair for the OS
and another for the WAL (pg_xlog directory).

Oh, and the database was over 3TB and growing fairly quickly.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin