Re: Partial index "microvacuum"

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Partial index "microvacuum"
Дата
Msg-id CAH2-Wz=n59hMLB4QozO+=DQg7GCDTjDo=03NBMYAFbNAQinGFw@mail.gmail.com
обсуждение исходный текст
Ответ на Partial index "microvacuum"  (Marko Tiikkaja <marko@joh.to>)
Ответы Re: Partial index "microvacuum"  (Marko Tiikkaja <marko@joh.to>)
Список 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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Ranier Vilela
Дата:
Сообщение: Re: Getting ERROR "subplan "SubPlan 1" was not initialized" in EXISTS subplan when using for list partition.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Hook for extensible parsing.