Skip site navigation (1) Skip section navigation (2)

Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.)

From: Tom Molesworth <tom(at)audioboundary(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.)
Date: 2010-06-25 16:39:05
Message-ID: 4C24DBA9.7030303@audioboundary.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 25/06/10 16:59, Rajesh Kumar Mallah wrote:
> when i reduce max_connections i start getting errors, i will see again 
> concurrent connections
> during business hours. lot of our connections are in <IDLE in 
> transaction state> during business
> this peculiar  behavior of  mod_perl servers have been discussed in 
> past i think. dont' remember
> if there was any resolution.

If connections spend any significant amount of time in <IDLE in 
transaction> state, that might indicate you're not committing/rolling 
back after running queries - can you show an example of the code you're 
using?

e.g. something like my $dbh = DBI->connect(...); my $sth = 
$dbh->prepare(q{select ... }); $sth->fetchall_arrayref; $sth->rollback;

Tom


In response to

Responses

pgsql-performance by date

Next:From: Kevin GrittnerDate: 2010-06-25 16:41:11
Subject: Re: Occasional giant spikes in CPU load
Previous:From: Craig JamesDate: 2010-06-25 16:16:57
Subject: Re: Occasional giant spikes in CPU load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group