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

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: [GSoC2014] Patch ALTER TABLE ... SET LOGGED
Дата
Msg-id
20140822202331.GS6343@eldon.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>
Fabrízio de Royes Mello wrote:
> On Fri, Aug 22, 2014 at 4:45 PM, Alvaro Herrera 
> wrote:

> > I pointed out, in the email just before pushing the patch, that perhaps
> > we should pass down the new relpersistence flag into finish_heap_swap,
> > and from there we could pass it down to reindex_index() which is where
> > it would be needed.  I'm not sure it's worth the trouble, but I think we
> > can still ask Fabrizio to rework that part.

> I can rework this part if it's a real concern.

I guess we can make a better assessment by seeing what it would take.
I'm afraid it will turn out to be really ugly.

Now, there's some desire to have unlogged indexes on logged tables; I
guess if we have that, then eventually there will also be a desire to
swap individual indexes from logged to unlogged.  Perhaps whatever fix
we come up with here would pave the road for that future feature.

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


В списке pgsql-hackers по дате отправления
От: Fabrízio de Royes Mello
Дата:
От: Tom Lane
Дата:
FAQ