Re: Vacuum full on a big table

Поиск
Список
Период
Сортировка
От Gaetano Mendola
Тема Re: Vacuum full on a big table
Дата
Msg-id 4239FC4D.40501@bigfoot.com
обсуждение исходный текст
Ответ на Re: Vacuum full on a big table  (Scott Marlowe <smarlowe@g2switchworks.com>)
Ответы Re: Vacuum full on a big table  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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-----


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Ales Vojacek"
Дата:
Сообщение: log into database
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Vacuum full on a big table