Re: Vacuum full on a big table

From: "Lee Wu" <Lwu(at)mxlogic(dot)com>
To: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Vacuum full on a big table
Date: 2005-03-17 21:28:45
Message-ID: ECAB83AA52BCC043A0E24BBC00001024D2E6A2@mxhq-exch.corp.mxlogic.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I wish.

I am having a table, size of more than 60G, with 2.04412e+08 rows.
Vacuum full and reindex it just kill me.

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Gaetano Mendola
Sent: Thursday, March 17, 2005 2:10 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: [ADMIN] Vacuum full on a big table

-----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-----

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ales Vojacek 2005-03-17 21:49:47 log into database
Previous Message Scott Marlowe 2005-03-17 21:20:22 Re: Vacuum full on a big table