pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Martin Foster <martin@ethereal-realms.org>
To: pgsql-performance@postgresql.org
Subject: Restricting Postgres
Date: Tue, 02 Nov 2004 23:52:12 GMT
Message-ID: <M4Vhd.85137$9b.34888@edtnps84> (raw)

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



view thread (34+ messages)  latest in thread

Message-ID: <M4Vhd.85137$9b.34888@edtnps84>
Permalink:  ../M4Vhd.85137$9b.34888@edtnps84/
Also on:    postgresql.org/message-id/M4Vhd.85137$9b.34888@edtnps84

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: martin@ethereal-realms.org
  Subject: Re: Restricting Postgres
  In-Reply-To: <M4Vhd.85137$9b.34888@edtnps84>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox