Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pailloncy Jean-Gerard <jg(at)rilk(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Error in VACUUM FULL VERBOSE ANALYZE (not enough memory)
Date: 2004-12-17 22:20:47
Message-ID: 24692.1103322047@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Pailloncy Jean-Gerard <jg(at)rilk(dot)com> writes:
> Update to my case:
> I drop and recreate the index and there was no problem this time.
> Strange...

Well, that time there wasn't actually any work for VACUUM FULL to do.
I think the bloat is probably driven by having to move a lot of rows
in order to shrink the table. That means creating and deleting a lot
of index entries.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Frank Wiles 2004-12-17 23:02:29 Re: Seqscan rather than Index
Previous Message Steinar H. Gunderson 2004-12-17 22:09:07 Re: Seqscan rather than Index