On Thu, Mar 10, 2011 at 12:52 PM, Greg Stark <gsst...@mit.edu> wrote: > 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.
Oh, I didn't even think about that. Yeah, that could be it, too. So maybe VACUUM FULL - crash before checkpoint - problem with recovery? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers