Re: Fwd: index corruption in PG 8.3.13 - Mailing list pgsql-hackers

From Greg Stark
Subject Re: Fwd: index corruption in PG 8.3.13
Date
Msg-id AANLkTinFKsP_yv0vswBjW4c1Mx9fhwNUE13_HYLzPujv@mail.gmail.com
Whole thread Raw
In response to Re: Fwd: index corruption in PG 8.3.13  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Fwd: index corruption in PG 8.3.13
List pgsql-hackers
On Thu, Mar 10, 2011 at 1:45 PM, Robert Haas <robertmhaas@gmail.com> wrote:
> 1. Somebody inserts a bunch of new tuples into the relation, causing
> growth in the index.

In case it's not obvious VACUUM FULL would do precisely that.

> 2. Before the blocks are written to disk, system crash.
> 3. pg_resetxlog

Do you have any record of the VACUUM FULL committing? Do you know what
LSN its commit record is at?

-- 
greg


pgsql-hackers by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Read uncommitted ever possible?
Next
From: Jesper Krogh
Date:
Subject: Re: Read uncommitted ever possible?