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
>
>
>