Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 9808E9FA108 for ; Tue, 28 Aug 2007 11:27:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 27563-04 for ; Tue, 28 Aug 2007 11:27:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 23ECF9FA128 for ; Tue, 28 Aug 2007 11:26:59 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1IQ21y-0008G2-Au for pgsql-performance@postgresql.org; Tue, 28 Aug 2007 10:26:58 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id C633D404E; Tue, 28 Aug 2007 10:26:52 -0400 (EDT) Date: Tue, 28 Aug 2007 10:26:52 -0400 From: Andrew Sullivan To: pgsql-performance@postgresql.org Subject: Re: server performance issues - suggestions for tuning Message-ID: <20070828142652.GB739@phlogiston.dyndns.org> References: <200708272213.14277.kevin@kevinkempterllc.com> <46D3D8D6.EE98.0025.0@wicourts.gov> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <46D3D8D6.EE98.0025.0@wicourts.gov> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/342 X-Sequence-Number: 26472 On Tue, Aug 28, 2007 at 08:12:06AM -0500, Kevin Grittner wrote: > > Is there any way to queue up these queries and limit how many are running at > a time? Sure: limit the number of connections to the database, and put a pool in front. It can indeed help. If you have a lot of bloat due to large numbers of failed vacuums, however, I suspect your problem is I/O. Vacuum churns through the disk very aggressively, and if you're close to your I/O limit, it can push you over the top. A -- Andrew Sullivan | ajs@crankycanuck.ca "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler