Postgres Pro
Downloads
Home   >   mailing lists

Re: data doesnt get saved in the database / idle in transaction - Mailing list pgsql-performance

From Qingqing Zhou
Subject Re: data doesnt get saved in the database / idle in transaction
Date
Msg-id dvm5sb$qh6$1@news.hub.org
Whole thread Raw
In response to data doesnt get saved in the database / idle in transaction  ("Ksenia Marasanova" <ksenia.marasanova@gmail.com>)
Responses Re: data doesnt get saved in the database / idle in transaction  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
Tree view 
""Ksenia Marasanova"" <ksenia.marasanova@gmail.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

pgsql-performance by date:

Previous
From: "Ksenia Marasanova"
Date:
Subject: data doesnt get saved in the database / idle in transaction
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Best OS & Configuration for Dual Xeon w/4GB &