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

From: Qingqing Zhou
Subject: Re: data doesnt get saved in the database / idle in transaction
Date: ,
Msg-id: dvm5sb$qh6$1@news.hub.org
(view: Whole thread, Raw)
In response to: data doesnt get saved in the database / idle in transaction  ("Ksenia Marasanova")
Responses: Re: data doesnt get saved in the database / idle in transaction  ("Jim C. Nasby")
List: pgsql-performance

""Ksenia Marasanova"" <> 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:

From: Dave Cramer
Date:
Subject: Re: Migration study, step 1: bulk write performance optimization
From: Vivek Khera
Date:
Subject: Re: 1 TB of memory