Re: Autovac cancellation is broken in v14 - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: Autovac cancellation is broken in v14
Date
Msg-id CAMkU=1zB0hqN8NChuvT00tMvxHEx=_-WZU4x6OO77kkFzD2ccA@mail.gmail.com
Whole thread Raw
In response to Autovac cancellation is broken in v14  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: Autovac cancellation is broken in v14
List pgsql-hackers

On Thu, Aug 27, 2020 at 3:10 PM Jeff Janes <jeff.janes@gmail.com> wrote:
If I create a large table with "CREATE TABLE ... AS SELECT ... from generate_series(1,3e7)" with no explicit transactions, then once it is done I wait for autovac to kick in, then when I try to build an index on that table (or drop the table) the autovac doesn't go away on its own.

After a bit more poking at this, I think we are checking if we ourselves are an autovac process, not doing the intended check of whether the other guy is one.

Where would be a good spot to add a regression test for this?  "isolation_regression" ?
Cheers,

Jeff

Attachment

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach)
Next
From: Stephen Frost
Date:
Subject: Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach)