On Thu, Mar 10, 2011 at 1:45 PM, Robert Haas <robertmh...@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

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to