From: | Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com> |
---|---|
To: | Tom Molesworth <tom(at)audioboundary(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: sudden spurt in swap utilization (was:cpu bound postgresql setup.) |
Date: | 2010-06-25 19:00:35 |
Message-ID: | AANLkTils-kuUrmSMRmB1eplblsAf-hbbr6iU65Gtahj-@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Dear tom, we have autocommit off in dbi. Any commit or rollback from
the persistent modperl process immediately issues begin work; if the
modperl process is waiting for request the database backend remains in
idle in transaction state. Unless we modify data in a http request we
neighter issue a commit nor rollback.
On 6/25/10, Tom Molesworth <tom(at)audioboundary(dot)com> wrote:
> 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
>
>
> --
> Sent via pgsql-performance mailing list (pgsql-performance(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-performance
>
--
Sent from Gmail for mobile | mobile.google.com
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2010-06-25 19:01:32 | Re: pgbench results on a new server |
Previous Message | Craig James | 2010-06-25 18:53:01 | pgbench results on a new server |