Not so much load balancing as load limits

From: Kenneth Downs <ken(at)secdat(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Not so much load balancing as load limits
Date: 2006-08-09 14:22:20
Message-ID: 44D9EF9C.1060309@secdat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 Content-Type Size
ken.vcf text/x-vcard 186 bytes

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-08-09 14:26:37 Re: read only transaction, temporary tables
Previous Message Michael Fuhr 2006-08-09 14:04:18 Re: Tuning to speed select