| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Andres Freund <andres(at)anarazel(dot)de> |
| Cc: | Michael Paquier <michael(at)paquier(dot)xyz>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, Robert Haas <robertmhaas(at)gmail(dot)com>, Peter Geoghegan <pg(at)bowt(dot)ie>, Петър Славов <pet(dot)slavov(at)gmail(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY |
| Date: | 2022-05-31 17:35:58 |
| Message-ID: | 202205311735.6ee52cp3igf7@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On 2022-May-30, Andres Freund wrote:
> On 2022-05-30 22:40:39 +0200, Alvaro Herrera wrote:
> > c98763bf51bf Avoid spurious waits in concurrent indexing
> > f9900df5f949 Avoid spurious wait in concurrent reindex
> > d9d076222f5b VACUUM: ignore indexing operations with CONCURRENTLY
>
> That looks right, yes.
Sorry, after going through these commits again, this is a
misunderstanding on my part. The first two commits need not be
reverted; only the third one does, which is the one that changes the way
the system-wide Xmin is determined (the commit message says it affects
VACUUM, but naturally it affects HOT pruning as well.)
The point of the first two changes is to remove snapshot waits in CIC
and RC. Before those commits, each CIC would wait for all other CICs
and RCs in the system. AFAICS this is unrelated to the HOT-pruning bug.
--
Álvaro Herrera PostgreSQL Developer — https://www.EnterpriseDB.com/
"Para tener más hay que desear menos"
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Honza Horak | 2022-05-31 18:36:19 | PostgreSQL 14.3 plpython not compatible with Python 3.11 |
| Previous Message | Andrey Borodin | 2022-05-31 17:12:33 | Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY |