X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 20B033A4546 for ; Wed, 3 Nov 2004 19:24:01 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 59399-07 for ; Wed, 3 Nov 2004 19:23:50 +0000 (GMT) Received: from cmailg1.svr.pol.co.uk (cmailg1.svr.pol.co.uk [195.92.195.171]) by svr1.postgresql.org (Postfix) with ESMTP id 6183E3A1D9E for ; Wed, 3 Nov 2004 19:23:50 +0000 (GMT) Received: from modem-112.porcupine.dialup.pol.co.uk ([217.134.192.112] helo=[192.168.0.102]) by cmailg1.svr.pol.co.uk with esmtp (Exim 4.14) id 1CPQjU-0002tN-LY; Wed, 03 Nov 2004 19:23:48 +0000 Subject: Re: Restricting Postgres From: Simon Riggs To: Martin Foster Cc: pgsql-performance@postgresql.org In-Reply-To: References: Content-Type: text/plain Organization: 2nd Quadrant Message-Id: <1099509684.4320.2.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Wed, 03 Nov 2004 19:21:24 +0000 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/21 X-Sequence-Number: 8975 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