Hi, Kevin
We are using client side pg_bouncer, do you think it is also an acceptable option?
Thanks
Frank
On Wed, Jun 11, 2014 at 10:48 AM, Kevin Grittner <kgrittn@xxxxxxxxx> wrote:
Amit Sharma <asharma@xxxxxxxxxxx> wrote:
> "Kevin Grittner" <kgrittn@xxxxxxxxx> 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 hardwareIt had 16 cores and 256GB RAM, a RAID controller with 256MB
> configuration that you used for this setup?
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.
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
