Re: Partial index "microvacuum"
Peter Geoghegan <pg@bowt.ie>
From: Peter Geoghegan <pg@bowt.ie>
To: Marko Tiikkaja <marko@joh.to>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-09-15T16:25:33Z
Lists: pgsql-hackers
On Wed, Sep 15, 2021 at 7:18 AM Marko Tiikkaja <marko@joh.to> wrote: > So I've been looking at issues we used to have in production some time > ago which eventually lead us to migrating away from partial indexes in > some cases. In the end, I'm surprised how easy this (or at least a > similar case) was to reproduce. > (I've tested this on 9.6, v11 and v13. 13 seems to be a bit better > here, but not "fixed", I think.) What about v14? There were significant changes to the microvacuum/index deletion stuff in that release: https://www.postgresql.org/docs/14/btree-implementation.html#BTREE-DELETION -- Peter Geoghegan