Re: 0ut of Memory Error during Vacuum Analyze and Create Index - Mailing list pgsql-performance

From Tom Lane
Subject Re: 0ut of Memory Error during Vacuum Analyze and Create Index
Date
Msg-id 23300.1139955341@sss.pgh.pa.us
Whole thread Raw
In response to Re: 0ut of Memory Error during Vacuum Analyze and  ("Tomeh, Husam" <htomeh@firstam.com>)
List 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 by date:

Previous
From: "Tomeh, Husam"
Date:
Subject: Re: 0ut of Memory Error during Vacuum Analyze and
Next
From: "Adnan DURSUN"
Date:
Subject: Re: SQL Function Performance