Not so much load balancing as load limits - Mailing list pgsql-general

From Kenneth Downs
Subject Not so much load balancing as load limits
Date
Msg-id 44D9EF9C.1060309@secdat.com
Whole thread Raw
Responses Re: Not so much load balancing as load limits  ("Jim C. Nasby" <jnasby@pervasive.com>)
List 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.

Attachment

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Tuning to speed select
Next
From: Tom Lane
Date:
Subject: Re: read only transaction, temporary tables