On Wed, 2008-03-26 at 15:31 -0400, Tom Lane wrote:
> Brad Nicholson <bnichols@ca.afilias.info> writes:
> > We just took a test database down (PG 8.1.11) fairly hard (pulled a SAN
> It could be that but not necessarily. These could be pages that were
> allocated to put new tuples into, but the crash happened before the
> inserting transaction committed (and, in fact, before any of the
> associated WAL entries had made their way to disk -- else the empty
> pages would've been initialized during WAL replay).
>
> It would be easier to believe that if the uninitialized pages were all
> contiguous though. Do you know that this table was under heavy insert
> load at the time?
It was. This table is an insert only log table that was being heavily
was being heavily written to at the time of the crash.
Brad.