| From: | Michael Holzman <michaelholzman(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Autovacuum of independent tables |
| Date: | 2020-09-08 15:34:09 |
| Message-ID: | CAPNViJq_nTiHjmNWfU9mBH-82-2UpYpCeY-bh7mhWNEZJQRBZQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Holzman | 2020-09-08 15:38:34 | Re: Autovacuum of independent tables |
| Previous Message | Magnus Hagander | 2020-09-08 15:33:04 | Re: Autovacuum of independent tables |