Re: Autovacuum of independent tables - Mailing list pgsql-general

From Michael Holzman
Subject Re: Autovacuum of independent tables
Date
Msg-id CAPNViJq_nTiHjmNWfU9mBH-82-2UpYpCeY-bh7mhWNEZJQRBZQ@mail.gmail.com
Whole thread Raw
In response to Re: Autovacuum of independent tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Autovacuum of independent tables
Next
From: Michael Holzman
Date:
Subject: Re: Autovacuum of independent tables