Re: VACUUM ANALYZE out of memory - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: VACUUM ANALYZE out of memory
Date
Msg-id 1197368681.4255.1282.camel@ebony.site
Whole thread Raw
In response to VACUUM ANALYZE out of memory  (Michael Akinde <michael.akinde@met.no>)
Responses Re: VACUUM ANALYZE out of memory
List pgsql-hackers
On Tue, 2007-12-11 at 10:59 +0100, Michael Akinde wrote:

> I am encountering problems when trying to run VACUUM FULL ANALYZE on a 
> particular table in my database; namely that the process crashes out 
> with the following problem:

Probably just as well, since a VACUUM FULL on an 800GB table is going to
take a rather long time, so you are saved from discovering just how
excessively long it will run for. But it seems like a bug. This happens
consistently, I take it?

Can you run ANALYZE and then VACUUM VERBOSE, both on just
pg_largeobject, please? It will be useful to know whether they succeed.

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com



pgsql-hackers by date:

Previous
From: Stefan Kaltenbrunner
Date:
Subject: Re: VACUUM ANALYZE out of memory
Next
From: Simon Riggs
Date:
Subject: VLDB Features