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: | Raw Message | Whole Thread | 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 |