Not so much load balancing as load limits

Поиск
Список
Период
Сортировка
От Kenneth Downs
Тема Not so much load balancing as load limits
Дата
Msg-id 44D9EF9C.1060309@secdat.com
обсуждение исходный текст
Ответы Re: Not so much load balancing as load limits  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-general
I'm having some trouble getting a google hit on this topic, and the docs
aren't doing much for me.

What I'm wondering is, how do I limit any particular postgres operation,
in particular a long-running batch operation with lots of inserts, from
bogging down a server?

This is not so much a question of how to code the SQL, as it is how to
keep a selfish process from causing a self-inflicted DoS situation.

Can anybody get me pointed in the right direction with a link or two?
Thanks.

Вложения

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

Предыдущее
От: Michael Fuhr
Дата:
Сообщение: Re: Tuning to speed select
Следующее
От: Tom Lane
Дата:
Сообщение: Re: read only transaction, temporary tables