Re: Autovacuum of independent tables

Поиск
Список
Период
Сортировка
От Michael Holzman
Тема Re: Autovacuum of independent tables
Дата
Msg-id CAPNViJq_nTiHjmNWfU9mBH-82-2UpYpCeY-bh7mhWNEZJQRBZQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Autovacuum of independent tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general


On Tue, Sep 8, 2020 at 6:15 PM Tom Lane  wrote:
Well, we don't know what isolation level the OP is using. 
We use the default. We do not explicitly set the isolation level.

We also don't know what PG version he's using. 
it's 12.1

From memory, it hasn't been that long
since we fixed things so that an idle read-committed transaction
advertises no xmin.  It's also possible that the transaction isn't really
idle between statements (eg, if it's holding open cursors, or the like).
There are no open cursors.

--
Regards,
    Michael Holzman

В списке pgsql-general по дате отправления:

Предыдущее
От: Magnus Hagander
Дата:
Сообщение: Re: Autovacuum of independent tables
Следующее
От: Michael Holzman
Дата:
Сообщение: Re: Autovacuum of independent tables