Postgres Pro
Downloads
Home   >   mailing lists

Re: An out of memory error when doing a vacuum full - Mailing list pgsql-general

From Tom Lane
Subject Re: An out of memory error when doing a vacuum full
Date
Msg-id 15451.1072716304@sss.pgh.pa.us
Whole thread Raw
In response to An out of memory error when doing a vacuum full  (Sean Shanny <shannyconsulting@earthlink.net>)
Responses Re: An out of memory error when doing a vacuum full  (Sean Shanny <shannyconsulting@earthlink.net>)
List pgsql-general
Tree view 
Sean Shanny <shannyconsulting@earthlink.net> writes:
> Does anyone have an explanation as to why this might occur?

What have you got vacuum_mem set to?  Also, what ulimit settings is the
postmaster running under?  (I'm wondering exactly how large the backend
process has grown when it gets the failure.)

            regards, tom lane

pgsql-general by date:

Previous
From: Fernando Schapachnik
Date:
Subject: Re: An out of memory error when doing a vacuum full
Next
From: Tom Lane
Date:
Subject: Re: Out of memory error when doing an update with IN clause