Re: VACUUM FULL out of memory

Поиск
Список
Период
Сортировка
От Holger Hoffstaette
Тема Re: VACUUM FULL out of memory
Дата
Msg-id pan.2008.01.07.16.33.53.25750@wizards.de
обсуждение исходный текст
Ответ на VACUUM ANALYZE out of memory  (Michael Akinde <michael.akinde@met.no>)
Ответы Re: VACUUM FULL out of memory  ("Joshua D. Drake" <jd@commandprompt.com>)
Список pgsql-hackers
On Mon, 07 Jan 2008 10:57:53 -0500, Andrew Sullivan wrote:

> Note that you should almost never use VACUUM FULL unless you've really
> messed things up.  I understand from the thread that you're just testing
> things out right now.  But VACUUM FULL is not something you should _ever_
> need in production, if you've set things up correctly.

Then why does it exist? Is it a historical leftover? If it is
only needed for emergency, should it not have a different name?
Just curious..

Holger




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

Предыдущее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: Bug: Unreferenced temp tables disables vacuum to update xid
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: VACUUM FULL out of memory