From: Craig Ringer <craig@postnewspapers.com.au>
To: Harpreet singh Wadhwa <harpreetsingh.wadhwa@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Need help in performance tuning.
Date: Fri, 09 Jul 2010 11:11:02 +0800
Message-ID: <4C369346.6010501@postnewspapers.com.au> (raw)
In-Reply-To: <AANLkTiknhZhKtGDidBsMWtPJpRgln9DrrsCebCEYk5XE@mail.gmail.com>
References: <AANLkTiknhZhKtGDidBsMWtPJpRgln9DrrsCebCEYk5XE@mail.gmail.com>
On 9/07/2010 3:20 AM, Harpreet singh Wadhwa wrote:
> Hi,
>
>
> I want to fine tune my postgresql to increase number of connects it
> can handle in a minutes time.
> Decrease the response time per request etc.
> The exact case will be to handle around 100 concurrent requests.
If you're not using a connection pool, start using one.
Do you really need 100 *active* working query threads at one time?
Because if you do, you're going to need a scary-big disk subsystem and a
lot of processors.
Most people actually only need a few queries executing simultaneously,
they just need lots of connections to the database open concurrently
and/or lots of queries queued up for processing. For that purpose, a
connection pool is ideal.
You will get BETTER performance from postgresql with FEWER connections
to the "real" database that're all doing active work. If you need lots
and lots of connections you should use a connection pool to save the
main database the overhead of managing that.
--
Craig Ringer
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: craig@postnewspapers.com.au, harpreetsingh.wadhwa@gmail.com
Subject: Re: Need help in performance tuning.
In-Reply-To: <4C369346.6010501@postnewspapers.com.au>
* 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