Vacuum full on a big table - Mailing list pgsql-admin

From Gaetano Mendola
Subject Vacuum full on a big table
Date
Msg-id 4239F22C.4040401@bigfoot.com
Whole thread Raw
Responses Re: Vacuum full on a big table  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-admin
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi all,
is there a way to vacuum full a table but working only
a part of the table ? I have a table with 6 milion rows
and vacuum full it will send out of line for hours my
server, so I'll like to vacuum that table multiple times
in order to not block that table for a long period.

It will work decresing the FSM settings ?


Regards
Gaetano Mendola



-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCOfIs7UpzwH2SGd4RAsXaAKDIgcNZLqsYULjnNVNhTktXvWmJTgCg4zcK
V/gFNRTCu0y99HLbTtGm610=
=0SF3
-----END PGP SIGNATURE-----


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Best practice - Vacuum. Replication suggestions and pg vs mysql question
Next
From: Scott Marlowe
Date:
Subject: Re: Vacuum full on a big table