| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, Robert Haas <robertmhaas(at)gmail(dot)com>, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, David Rowley <dgrowleyml(at)gmail(dot)com> |
| Subject: | Autovac cancellation is broken in v14 |
| Date: | 2020-08-27 19:10:47 |
| Message-ID: | CAMkU=1wH2aUy+wDRDz+5RZALdcUnEofV1t9PzXS_gBJO9vZZ0Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
Bisects down to:
commit 5788e258bb26495fab65ff3aa486268d1c50b123
Author: Andres Freund <andres(at)anarazel(dot)de>
Date: Wed Jul 15 15:35:07 2020 -0700
snapshot scalability: Move PGXACT->vacuumFlags to
ProcGlobal->vacuumFlags.
Which makes sense given the parts of the code this touches, although I
don't understand exactly what the problem is. The problem persists in HEAD
(77c7267c37).
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2020-08-27 19:41:40 | Re: "cert" + clientcert=verify-ca in pg_hba.conf? |
| Previous Message | Stephen Frost | 2020-08-27 18:51:16 | Re: [EXTERNAL] Re: WIP: WAL prefetch (another approach) |