From: Simon Riggs <simon@2ndquadrant.com>
To: Martin Foster <martin@ethereal-realms.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: Restricting Postgres
Date: Wed, 03 Nov 2004 19:21:24 +0000
Message-ID: <1099509684.4320.2.camel@localhost.localdomain> (raw)
In-Reply-To: <M4Vhd.85137$9b.34888@edtnps84>
References: <M4Vhd.85137$9b.34888@edtnps84>
On Tue, 2004-11-02 at 23:52, 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
> 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.
Sounds great... could you give more shape to the idea, so people can
comment on it?
What limit? Measured how? Normal operation is what?
Drop what? How to tell?
>
> 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.
You can limit the number of connections overall?
--
Best Regards, Simon Riggs
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: simon@2ndquadrant.com, martin@ethereal-realms.org
Subject: Re: Restricting Postgres
In-Reply-To: <1099509684.4320.2.camel@localhost.localdomain>
* 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