Re: VACUUM ANALYZE out of memory

Поиск
Список
Период
Сортировка
От Simon Riggs
Тема Re: VACUUM ANALYZE out of memory
Дата
Msg-id 1197368681.4255.1282.camel@ebony.site
обсуждение исходный текст
Ответ на VACUUM ANALYZE out of memory  (Michael Akinde <michael.akinde@met.no>)
Ответы Re: VACUUM ANALYZE out of memory
Список pgsql-hackers
On Tue, 2007-12-11 at 10:59 +0100, Michael Akinde wrote:

> I am encountering problems when trying to run VACUUM FULL ANALYZE on a 
> particular table in my database; namely that the process crashes out 
> with the following problem:

Probably just as well, since a VACUUM FULL on an 800GB table is going to
take a rather long time, so you are saved from discovering just how
excessively long it will run for. But it seems like a bug. This happens
consistently, I take it?

Can you run ANALYZE and then VACUUM VERBOSE, both on just
pg_largeobject, please? It will be useful to know whether they succeed.

--  Simon Riggs 2ndQuadrant  http://www.2ndQuadrant.com



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

Предыдущее
От: Stefan Kaltenbrunner
Дата:
Сообщение: Re: VACUUM ANALYZE out of memory
Следующее
От: Simon Riggs
Дата:
Сообщение: VLDB Features