Re: Autovacuum / full vacuum

Поиск
Список
Период
Сортировка
От Christopher Browne
Тема Re: Autovacuum / full vacuum
Дата
Msg-id m364ojrm4f.fsf@mobile.int.cbbrowne.com
обсуждение исходный текст
Ответ на Autovacuum / full vacuum  (Michael Riess <mlriess@gmx.de>)
Ответы Re: Autovacuum / full vacuum  (Michael Riess <mlriess@gmx.de>)
Список pgsql-performance
> I'm curious as to why autovacuum is not designed to do full vacuum.

Because that's terribly invasive due to the locks it takes out.

Lazy vacuum may chew some I/O, but it does *not* block your
application for the duration.

VACUUM FULL blocks the application.  That is NOT something that anyone
wants to throw into the "activity mix" randomly.
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/slony.html
Signs of a Klingon Programmer #11: "This machine is a piece of GAGH! I
need dual Pentium processors if I am to do battle with this code!"

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

Предыдущее
От: Markus Schaber
Дата:
Сообщение: Re: new to postgres (and db management) and performance
Следующее
От: Michael Riess
Дата:
Сообщение: Re: Autovacuum / full vacuum