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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED]





---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Reply via email to