Restricting Postgres
| От | Martin Foster |
|---|---|
| Тема | Restricting Postgres |
| Дата | |
| Msg-id | M4Vhd.85137$9b.34888@edtnps84 обсуждение исходный текст |
| Ответы |
Re: Restricting Postgres
Re: Restricting Postgres |
| Список | 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@ethereal-realms.org
В списке pgsql-performance по дате отправления: