Re: switch UNLOGGED to LOGGED - Mailing list pgsql-hackers

From Leonardo Francalanci
Subject Re: switch UNLOGGED to LOGGED
Date
Msg-id 826909.74063.qm@web29018.mail.ird.yahoo.com
Whole thread Raw
In response to Re: switch UNLOGGED to LOGGED  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: switch UNLOGGED to LOGGED  (Noah Misch <noah@leadboat.com>)
List 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 by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Transforming IN (...) to ORs, volatility
Next
From: Albert Cervera i Areny
Date:
Subject: developer.postgresql.org down