Re: [Autovacuum] Issue to understand some logs - Mailing list pgsql-admin

From Tom Lane
Subject Re: [Autovacuum] Issue to understand some logs
Date
Msg-id 26830.1355763665@sss.pgh.pa.us
Whole thread Raw
In response to Re: [Autovacuum] Issue to understand some logs  (Baptiste LHOSTE <blhoste@alaloop.com>)
Responses Re: [Autovacuum] Issue to understand some logs
List pgsql-admin
Baptiste LHOSTE <blhoste@alaloop.com> writes:
>> As I said, because they are still visible to other transactions. Try to
>> see if you have long-lasting transactions.

> How can I do that ? I check running query in pg_stat_activity, but there is no query on that table.

Does "select * from pg_prepared_xacts" find anything?

            regards, tom lane


pgsql-admin by date:

Previous
From: Baptiste LHOSTE
Date:
Subject: Re: [Autovacuum] Issue to understand some logs
Next
From: Baptiste LHOSTE
Date:
Subject: Re: [Autovacuum] Issue to understand some logs