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