Re: switch UNLOGGED to LOGGED

Поиск
Список
Период
Сортировка
От Leonardo Francalanci
Тема Re: switch UNLOGGED to LOGGED
Дата
Msg-id 826909.74063.qm@web29018.mail.ird.yahoo.com
обсуждение исходный текст
Ответ на Re: switch UNLOGGED to LOGGED  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: switch UNLOGGED to LOGGED  (Noah Misch <noah@leadboat.com>)
Список pgsql-hackers
> > But re-reading  it, I don't understand: what's the difference in creating
> > a new  "regular" table and crashing before emitting the abort record,
> > and  converting an unlogged table to logged and crashing before
> > emitting the  abort record? How do the standby servers handle a
> > "CREATE TABLE"  followed by a ROLLBACK if the master crashes
> > before writing the abort  record? I thought that too would "leave a
> > stray file around on a  standby".
>
> I've been thinking about the same thing.  And AFAICS, your  analysis is
> correct, though there may be some angle to it I'm not  seeing.


Anyone else? I would like to know if what I'm trying to do is, in fact,
possible... otherwise starting with thewal_level=minimal case first
will be wasted effort in case the other cases can't be integrated
somehow...



Leonardo


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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Transforming IN (...) to ORs, volatility
Следующее
От: Albert Cervera i Areny
Дата:
Сообщение: developer.postgresql.org down