Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
От
Tom Lane
Тема
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
Дата
Msg-id
10046.1527441741@sss.pgh.pa.us
Ответ на
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid (Andres Freund)
Список
Дерево обсуждения
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Tom Lane <tgl@sss.pgh.pa.us>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund <andres@anarazel.de>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund <andres@anarazel.de>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Alvaro Herrera <alvherre@2ndquadrant.com>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Alvaro Herrera <alvherre@2ndquadrant.com>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund <andres@anarazel.de>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund <andres@anarazel.de>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund <andres@anarazel.de>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Matheus de Oliveira <matioli.matheus@gmail.com>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund <andres@anarazel.de>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Sergey Burladyan <eshkinkot@gmail.com>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund <andres@anarazel.de>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Matheus de Oliveira <matioli.matheus@gmail.com>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jerry Sievers <gsievers19@comcast.net>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Kyle Samson <kysamson@tripadvisor.com>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Peter Geoghegan <pg@bowt.ie>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Bruce Momjian <bruce@momjian.us>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Matheus de Oliveira <matioli.matheus@gmail.com>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund <andres@anarazel.de>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Jeremy Finzel <finzelj@gmail.com>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid "Nishant, Fnu" <nishantf@amazon.com>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund <andres@anarazel.de>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid "Nishant, Fnu" <nishantf@amazon.com>
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid Andres Freund <andres@anarazel.de>
Andres Freund writes: > On May 27, 2018 9:39:49 AM PDT, "Nasby, Jim" wrote: >> How about only keeping the critical info for being able to find >> relations in the .init files, and then fully populate the cache by >> doing a normal lookup? > Then the cache wouldn't have any benefits, no? It's been a while, but last time I checked it does make quite a measurable performance difference in a new backend. Yeah, we don't want to lose the performance benefit. But I don't think there's any need for special magic here: we just have to accept the fact that there's a need to flush that cache sometimes. In normal use it shouldn't happen often enough to be a performance problem. FWIW, I'm not on board with "memcpy the whole row". I think the right thing is more like what we do in RelationReloadIndexInfo, ie copy over the specific fields that we expect to be mutable. regards, tom lane
В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата: