Re: An out of memory error when doing a vacuum full

 From postgresql.conf:

# - Memory -

shared_buffers = 10000          # min 16, at least max_connections*2,
8KB each
sort_mem = 64000                # min 64, size in KB
vacuum_mem = 32767              # min 1024, size in KB

The ulimit is set to unlimited as far as I can tell.

--sean

Tom Lane wrote:

>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
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
>