Re: Vacuum - Out of memory

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Vacuum - Out of memory
Дата
Msg-id 3549.1138718172@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Vacuum - Out of memory  ("Tomeh, Husam" <htomeh@firstam.com>)
Список pgsql-admin
"Tomeh, Husam" <htomeh@firstam.com> writes:
> ThanksTom. I've asked the SA to bounce the server thinking it may be a
> memory fragmentation issue on the server. After bouncing the server, I
> was able to run vacuum successfully. (Before bouncing the server, I
> tried a lower value of maintenance_work_mem of 512MB and vacuum worked
> fine which made me feel better the status of data not being corrupted).
> Do you agree with me at this point that it's not a data corruption
> issue? Thanks again.

No, I don't, unless you have fields in the database that *should* be
1-billion-and-change bytes long.

            regards, tom lane

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

Предыдущее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: Vacuum - Out of memory
Следующее
От: Düster Horst
Дата:
Сообщение: query to select the table primary key column name