ncm(at)zembu(dot)com (Nathan Myers) writes:
> It Seems to Me that after an orderly shutdown, the WAL files should be,
> effectively, slag -- they should contain no deltas from the current
> table contents. In practice that means the only part of the format that
> *should* matter is whatever it takes to discover that they really are
> slag.
> That *should* mean that, at worst, a change to the WAL file format should
> only require doing an orderly shutdown, and then (perhaps) running a simple
> program to generate a new-format empty WAL. It ought not to require an
> initdb.
Excellent point, considering that we were already thinking of making a
handy-dandy little utility to remove broken WAL files... Shouldn't take
much more than that to build something that also reformats pg_control.
Thanks for the suggestion!
regards, tom lane
In response to
pgsql-hackers by date
| Next: | From: Christof Petig | Date: 2001-03-03 11:30:58 |
| Subject: Query Planning time increased 3 times on 7.1 compared to 7.0.3 |
| Previous: | From: Tom Lane | Date: 2001-03-03 00:13:29 |
| Subject: Re: Re: Turkish locale bug |