Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED
Дата
Msg-id
20141117132756.GW1791@alvin.alvh.no-ip.org
Ответ на
Список
Дерево обсуждения
[GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Christoph Berg <cb@df7cb.de>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Christoph Berg <cb@df7cb.de>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Christoph Berg <cb@df7cb.de>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Christoph Berg <cb@df7cb.de>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Christoph Berg <cb@df7cb.de>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Andres Freund <andres@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Andres Freund <andres@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Andres Freund <andres@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Andres Freund <andres@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Christoph Berg <cb@df7cb.de>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Thom Brown <thom@linux.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Christoph Berg <cb@df7cb.de>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Thom Brown <thom@linux.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Heikki Linnakangas <hlinnakangas@vmware.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Andres Freund <andres@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Robert Haas <robertmhaas@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Tom Lane <tgl@sss.pgh.pa.us>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Michael Paquier <michael.paquier@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Michael Paquier <michael.paquier@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Christian Ullrich <chris@chrullrich.net>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Michael Paquier <michael.paquier@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Tom Lane <tgl@sss.pgh.pa.us>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Michael Paquier <michael.paquier@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Tom Lane <tgl@sss.pgh.pa.us>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Andres Freund <andres@2ndquadrant.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED Fabrízio de Royes Mello <fabriziomello@gmail.com>
Michael Paquier wrote:

> The complaint comes from jaguarundi, like here:
> http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jaguarundi&dt=2014-11-16%2015%3A33%3A23
> 
> As Tom mentioned, adding a new parameter to set the persistence
> through RelationSetNewRelfilenode works. Patch, actually tested with
> CLOBBER_CACHE_ALWAYS, attached.

I wrote an identical patch on Saturday and watched it pass
CLOBBER_CACHE_ALWAYS test on Sunday.  But the reason I didn't push is I
couldn't understand *why* is there a problem here.  I imagine that the
source of the issue is supposed to be a relcache invalidation that takes
place (in the original code) after reindex_index changes relpersistence,
and before RelationSetNewRelfilenode() creates the filenode.  But at
what point does that code absorb invalidation messages?  Or is there a
completely different mechanism that causes the problem?  If so, what?

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


В списке pgsql-hackers по дате отправления
От: Alex Shulgin
Дата:
От: Alvaro Herrera
Дата:
FAQ