Re: [Autovacuum] Issue to understand some logs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [Autovacuum] Issue to understand some logs
Дата
Msg-id 26830.1355763665@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [Autovacuum] Issue to understand some logs  (Baptiste LHOSTE <blhoste@alaloop.com>)
Ответы Re: [Autovacuum] Issue to understand some logs  (Baptiste LHOSTE <blhoste@alaloop.com>)
Список 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 по дате отправления:

Предыдущее
От: Baptiste LHOSTE
Дата:
Сообщение: Re: [Autovacuum] Issue to understand some logs
Следующее
От: Baptiste LHOSTE
Дата:
Сообщение: Re: [Autovacuum] Issue to understand some logs