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(at)earthlink(dot)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(at)postgresql(dot)org
>
>
>