From: Valentin Bogdanov <valiouk@yahoo.co.uk>
To: pgsql-performance@postgresql.org
Subject: postgres overall performance seems to degrade when large SELECT are requested
Date: Wed, 14 May 2008 10:00:39 +0000 (GMT)
Message-ID: <942836.27599.qm@web25805.mail.ukl.yahoo.com> (raw)
HI,
I have an application that maintains 150 open connections to a Postgres DB server. The application works fine without a problem for the most time.
The problem seem to arise when a SELECT that returns a lot of rows is executed or the SELECT is run on a large object. These selects are run from time to time by a separate process whose purpose is to generate reports from the db data.
The problem is that when the SELECTs are run the main application starts running out of available connections which means that postgres is not returning the query results fast enough. What I find a little bit starnge is that the report engine's SELECTs operate on a different set of tables than the ones the main application is using. Also the db box is hardly breaking a sweat, CPU and memory utilization are ridiculously low and IOwaits are typically less than 10%.
Has anyone experienced this? Are there any settings I can change to improve throughput? Any help will be greatly appreciated.
Thanks,
val
__________________________________________________________
Sent from Yahoo! Mail.
A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html
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: valiouk@yahoo.co.uk
Subject: Re: postgres overall performance seems to degrade when large SELECT are requested
In-Reply-To: <942836.27599.qm@web25805.mail.ukl.yahoo.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