Re: error "can only drop stats once" brings down database

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: error "can only drop stats once" brings down database
Дата
Msg-id
ZnpA5zqSgW2FfqYF@paquier.xyz
Ответ на
Список
Дерево обсуждения
error "can only drop stats once" brings down database Floris Van Nee <florisvannee@Optiver.com>
Re: error "can only drop stats once" brings down database Tom Lane <tgl@sss.pgh.pa.us>
RE: error "can only drop stats once" brings down database Floris Van Nee <florisvannee@Optiver.com>
Re: error "can only drop stats once" brings down database Andres Freund <andres@anarazel.de>
Re: error "can only drop stats once" brings down database Andres Freund <andres@anarazel.de>
RE: error "can only drop stats once" brings down database Floris Van Nee <florisvannee@Optiver.com>
RE: error "can only drop stats once" brings down database Floris Van Nee <florisvannee@Optiver.com>
Re: error "can only drop stats once" brings down database Michael Paquier <michael@paquier.xyz>
RE: error "can only drop stats once" brings down database Floris Van Nee <florisvannee@Optiver.com>
Re: error "can only drop stats once" brings down database Michael Paquier <michael@paquier.xyz>
Re: error "can only drop stats once" brings down database Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: error "can only drop stats once" brings down database Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: error "can only drop stats once" brings down database Michael Paquier <michael@paquier.xyz>
Re: error "can only drop stats once" brings down database Andres Freund <andres@anarazel.de>
Re: error "can only drop stats once" brings down database Bertrand Drouvot <bertranddrouvot.pg@gmail.com>
Re: error "can only drop stats once" brings down database Michael Paquier <michael@paquier.xyz>
RE: error "can only drop stats once" brings down database Floris Van Nee <florisvannee@Optiver.com>
Re: error "can only drop stats once" brings down database Michael Paquier <michael@paquier.xyz>
RE: error "can only drop stats once" brings down database Floris Van Nee <florisvannee@Optiver.com>
Re: error "can only drop stats once" brings down database Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: error "can only drop stats once" brings down database Michael Paquier <michael@paquier.xyz>
Re: error "can only drop stats once" brings down database Michael Paquier <michael@paquier.xyz>
Re: error "can only drop stats once" brings down database Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Re: error "can only drop stats once" brings down database Michael Paquier <michael@paquier.xyz>
Re: error "can only drop stats once" brings down database Tom Lane <tgl@sss.pgh.pa.us>
Re: error "can only drop stats once" brings down database Alexander Lakhin <exclusion@gmail.com>
On Tue, Jun 25, 2024 at 09:22:48AM +0900, Kyotaro Horiguchi wrote:
> Is it something like this? I forgot the reason why this was excluded
> from the vinal version, though.
> 
> https://www.postgresql.org/message-id/20201001.090722.322196928507744460.horikyota.ntt%40gmail.com

That's a bit different than the gc_count presented in 0004, because
there is no relationship to autovacuum with the cleanup of the
entries, still there is some overlap in the thought process: this
suggestion just makes sure that any backend holding local references
to a shared entry with a different age does not attempt to manipulate
it after switching locally to a dropped state. 
--
Michael
В списке pgsql-bugs по дате отправления
От: Richard Guo
Дата:
От: Antti Lampinen
Дата:
FAQ