Re: switch UNLOGGED to LOGGED

Поиск
Список
Период
Сортировка
От Noah Misch
Тема Re: switch UNLOGGED to LOGGED
Дата
Msg-id 20110519192438.GA7705@tornado.gateway.2wire.net
обсуждение исходный текст
Ответ на Re: switch UNLOGGED to LOGGED  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: switch UNLOGGED to LOGGED
Список pgsql-hackers
On Thu, May 19, 2011 at 11:42:03AM -0400, Robert Haas wrote:
> On Thu, May 19, 2011 at 11:13 AM, Noah Misch <noah@leadboat.com> wrote:
> > It would solve the problem, but it would mean resetting unlogged relations on
> > the standby at every shutdown checkpoint. ?That's probably not a performance
> > problem, but it is a hack.
> 
> I haven't thought about this too deeply, but I'm not sure I agree
> that's a hack.  Why do you think it is?

It would make the standby reset unlogged relations on both regular shutdowns and
crashes, while the master only does so on crashes.  This creates no functional
hazard since unlogged relation contents are never accessible during hot standby.
It seems like a hack to rely on that fact at any distance, but perhaps a comment
is enough to assuage that.

nm


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: moving toast table to its own tablespace
Следующее
От: Robert Haas
Дата:
Сообщение: Re: LOCK DATABASE