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
|
Список | 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 по дате отправления: