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