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

From: "Nikolay Mijaylov" <nmmm(at)nmmm(dot)nu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: URGENT: pgsql on the web server - memory problems....
Date: 2000-10-05 10:28:15
Message-ID: NDBBJGGFCLFEEGHHKCABIEHBDGAA.nmmm@nmmm.nu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all
I;m not sure how to explain this

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

the server is linux machine with 64MB RAM and 200 MB swap on the disk. One
HDD 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
postgres 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,
freeze :)

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

My question is : is there a way to limit the memory (and CPU time) used by
postgres 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 >

Browse pgsql-general by date

  From Date Subject
Next Message Nikolay Mijaylov 2000-10-05 12:21:07 FW: URGENT: pgsql on the web server - memory problems....
Previous Message Tim Uckun 2000-10-05 09:42:47 Re: VIEW problem