Re: Restricting Postgres

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Restricting Postgres
Дата
Msg-id 20041103141743.GA15499@phlogiston.dyndns.org
обсуждение исходный текст
Ответ на Restricting Postgres  (Martin Foster <martin@ethereal-realms.org>)
Список pgsql-performance
On Tue, Nov 02, 2004 at 11:52:12PM +0000, Martin Foster wrote:
> 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

Well, you could limit the number of concurrent connections, and set
the query timeout to a relatively low level.  What that ought to mean
is that, under heavy load, some queries will abort.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
When my information changes, I alter my conclusions.  What do you do sir?
        --attr. John Maynard Keynes

В списке pgsql-performance по дате отправления:

Предыдущее
От: Martin Foster
Дата:
Сообщение: Restricting Postgres
Следующее
От:
Дата:
Сообщение: preloading indexes