FW: URGENT: pgsql on the web server - memory problems....

--------------------------------------------------------------
The reboots are for hardware upgrades!
"http://www.nmmm.nu"; < nmmm(at)nmmm(dot)nu >

-----Original Message-----
From: Nikolay Mijaylov [mailto:nmmm(at)nmmm(dot)nu]
Sent: Thursday, October 05, 2000 1:28 PM
To: pgsql-general(at)postgresql(dot)org
Subject: URGENT: pgsql on the web server - memory problems....

Hi all
I;m not sure how to explain this

we have a web server with several clients which uses PostgreSQL. Currently v
ersion 7.0.2

the server is linux machine with 64MB RAM and 200 MB swap on the disk. One H
DD partition with free disk space about 1.5 GB.

i started the server with:
postmaster -N 64 -B 256

Unfortunately one of our clients runs wery big database and very big (fuckin
' strange complex) queries using PHP.

The problem is that PHP is auto killing after a while (1-2 min), but the pos
tgres backend process stay (and works about 2 or many more hours). Soon all
Linux is filled with 64 postgres processes, free memory is 0 and Linux, free
ze :)

These queries freeze our computer and it stops responding. The only way we c
an do is to press "reset" button.

My question is : is there a way to limit the memory (and CPU time) used by p
ostgres processes by our clients. Can we make auto kill like in PHP?

I play with ulimit and think it is not a such a good idea....
For a moment I stop this client and do

postmaster -N 24 -B 64

...

Any Suggestions?

Thank you

--------------------------------------------------------------
The reboots are for hardware upgrades!
"http://www.nmmm.nu"; < nmmm(at)nmmm(dot)nu >