On Thu, Sep 16, 2021 at 4:45 AM Marko Tiikkaja wrote:
> Huh. Interesting. I'm sorry, I wasn't aware of this work and didn't
> have version 14 at hand. But it looks like both the partial index as
> well as the secondary index on (id::text) get cleaned up nicely there.
That's great.
I understan
On Wed, Sep 15, 2021 at 7:25 PM Peter Geoghegan wrote:
> 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
Huh. Interesting. I'm sorry, I wasn't aware of this
On Wed, Sep 15, 2021 at 7:18 AM Marko Tiikkaja 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 repro
