Re: found xmin from before relfrozenxid on pg_catalog.pg_authid

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
Дата
в 20:22:21
Msg-id
10046.1527441741@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
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
Дата:
От: Jonathan S. Katz
Дата:
FAQ