| From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Vacuum full on a big table |
| Date: | 2005-03-17 21:53:17 |
| Message-ID: | 4239FC4D.40501@bigfoot.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Scott Marlowe wrote:
>
> Vacuum full doesn't use fsm, lazy vacuum does (i.e. plain vacuum).
Are you sure? Why then after a vacuum full verbose the FSM settings
are displayed ?
> Is there a reason you're doing a full vacuum?
Because I'm only running pg_autovacuum since one month now, but I see
that for same table is a disaster do not vacuum full once in a day.
> and no, you can't vacuum parts at a time. it's all or nothing.
> (*Unless that changes in 8.0...*)
I wish that this happen.
Regards
Gaetano Mendola
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.5 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCOfxN7UpzwH2SGd4RArg0AKDn4hDw6aiaQgHW18xBfUsCNWqurgCgtaVj
fmDWcXtK+kZsrdSbY6rw3LA=
=zZEC
-----END PGP SIGNATURE-----
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Oleg Bartunov | 2005-03-17 22:00:12 | Re: Vacuum full on a big table |
| Previous Message | Ales Vojacek | 2005-03-17 21:49:47 | log into database |