Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group