- www.htminer.it
-Messaggio originale-
Da: Scott Marlowe [mailto:[EMAIL PROTECTED]
Inviato: mercoledì 2 maggio 2007 17.41
A: Gabriele Bartolini
Cc: pgsql-admin@postgresql.org
Oggetto: Re: [ADMIN] VACUUM FULL ANALYSE hanging
On Wed, 2007-05-02 at 05:05, Gabriele Bartolini wrote:
Hi guys
Hi guys,
I am having problems with freeing disk space after a massive delete
operation on a table that had approximately 80 million record. I ran the
following command, by setting the vacuum memory to approximately a GigaByte:
SET vacuum_mem TO 1024000
VACUUM FULL ANALYSE VERBOSE
I've noticed in my own experiments and experiences with VACUUM FULL that
it tries to reindex all the indexes to compress them. While a good idea,
this unfortunately takes a *long* time.
You should check two things. First, the server CPU usage should be high
(~100% if on a single core).
On Wed, 2007-05-02 at 05:05, Gabriele Bartolini wrote:
Hi guys,
I am having problems with freeing disk space after a massive delete
operation on a table that had approximately 80 million record. I
ran the following command, by setting the vacuum memory to
approximately a GigaByte:
Peter Koczan escribió:
I've noticed in my own experiments and experiences with VACUUM FULL that
it tries to reindex all the indexes to compress them. While a good idea,
this unfortunately takes a *long* time.
Huh, this is not an accurate description of what happens. VACUUM FULL
tries to