On Fri, Apr 29, 2011 at 1:13 AM, Qiang Wang wrote:
>
> We have 10GB memory and we tuned PostgreSQL as follow:
> - max_connection = 100
> - work_mem = 50MB
You do know that work_mem is PER SORT right? Not per connection or
per user or per database. If all 100 of those connections needs to do
a
Normally under heavy load, a machine could potential stall, even seem to hang,
but not crash.
And judging from your description of the situation your only change was in
shared memory (IPC shm) usage, right?
I would advise to immediately run all sorts of (offline/online) hardware tests
(especiall
As for the question in the title, no, if the server starts, shared
buffers should not be the reason for a subsequent crash.
In debian, it is common that the maximum allowed shared memory setting
on your kernel will prevent a server from even starting, but I guess
that's not your problem (because i
