| From: | Martin Foster <martin(at)ethereal-realms(dot)org> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Restricting Postgres |
| Date: | 2004-11-02 23:52:12 |
| Message-ID: | M4Vhd.85137$9b.34888@edtnps84 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Is there a way to restrict how much load a PostgreSQL server can take
before dropping queries in order to safeguard the server? I was
looking at the login.conf (5) man page and while it allows me to limit
by processor time this seems to not fit my specific needs.
Essentially, I am looking for a sort of functionality similar to what
Sendmail and Apache have. Once the load of the system reaches a
certain defined limit the daemon drops tasks until such a time that it
can resume normal operation.
While not necessarily common on my servers I have witnessed some fairly
high load averages which may have led to the machine dropping outright.
Any help on this matter would be appreciated.
--
Martin Foster
Creator/Designer Ethereal Realms
martin(at)ethereal-realms(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Tillotson | 2004-11-03 01:57:47 | Re: Numeric type problems |
| Previous Message | Steve Crawford | 2004-11-02 23:30:10 | Batch processing select |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2004-11-03 14:17:43 | Re: Restricting Postgres |
| Previous Message | Josh Berkus | 2004-11-02 05:58:35 | Re: Speeding up Gist Index creations |