Re: 0ut of Memory Error during Vacuum Analyze and Create Index

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 0ut of Memory Error during Vacuum Analyze and Create Index
Дата
Msg-id 23300.1139955341@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 0ut of Memory Error during Vacuum Analyze and  ("Tomeh, Husam" <htomeh@firstam.com>)
Список pgsql-performance
"Tomeh, Husam" <htomeh@firstam.com> writes:
> I have run pg_dump and had no errors. I also got this error when
> creating one index but not another. When I lowered my
> maintenance_work_mem, the create index succeeded.

Create index too?  Hm.  That begins to sound more like a memory leak.
Do you have any custom data types or anything like that in this
table?  Can you put together a self-contained test case using dummy
data?

            regards, tom lane

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

Предыдущее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: 0ut of Memory Error during Vacuum Analyze and
Следующее
От: "Adnan DURSUN"
Дата:
Сообщение: Re: SQL Function Performance