Re: {Spam} [PERFORM] Will shared_buffers crash a server

2011-05-01 Thread Marti Raudsepp
Qiang Wang wrote: > We have PostgreSQL 8.3 running on Debian Linux server. We built an > applicantion using PHP programming language and Postgres database. There are > appoximatly 150 users using the software constantly. We had some performance > degration before and after some studies we figured

Re: {Spam} [PERFORM] Will shared_buffers crash a server

2011-04-29 Thread French, Martin
] Will shared_buffers crash a server Hei: We have PostgreSQL 8.3 running on Debian Linux server. We built an applicantion using PHP programming language and Postgres database. There are appoximatly 150 users using the software constantly. We had some performance degration before and after

Re: [PERFORM] Will shared_buffers crash a server

2011-04-29 Thread Scott Marlowe
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

Re: [PERFORM] Will shared_buffers crash a server

2011-04-29 Thread Achilleas Mantzios
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

Re: [PERFORM] Will shared_buffers crash a server

2011-04-29 Thread Claudio Freire
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

[PERFORM] Will shared_buffers crash a server

2011-04-29 Thread Qiang Wang
Hei: We have PostgreSQL 8.3 running on Debian Linux server. We built an applicantion using PHP programming language and Postgres database. There are appoximatly 150 users using the software constantly. We had some performance degration before and after some studies we figured out we will need