On Thu, Mar 10, 2011 at 12:52 PM, Greg Stark <gsstark(at)mit(dot)edu> wrote:
> On Thu, Mar 10, 2011 at 1:45 PM, Robert Haas <robertmhaas(at)gmail(dot)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