Re: data doesnt get saved in the database / idle in transaction

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: data doesnt get saved in the database / idle in transaction
Date: 2006-03-20 12:03:14
Message-ID: dvm5sb$qh6$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


""Ksenia Marasanova"" <ksenia(dot)marasanova(at)gmail(dot)com> wrote
>
> The application uses persistant database connection, and when i check
> the status of the connection, it shows: "idle in transaction". I am
> pretty sure that every insert is being committed with explicit
> "commit()" . It always worked before.... weird.
>

Try to use the following command to see what commands reach the server:

set log_statement = "all";

Regards,
Qingqing

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim C. Nasby 2006-03-20 14:45:04 Re: Best OS & Configuration for Dual Xeon w/4GB &
Previous Message Ksenia Marasanova 2006-03-20 10:46:11 data doesnt get saved in the database / idle in transaction