X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id ED6D79FB2F8 for ; Wed, 9 Aug 2006 18:20:52 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 17573-03 for ; Wed, 9 Aug 2006 18:20:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id DF0359FB1F0 for ; Wed, 9 Aug 2006 18:20:47 -0300 (ADT) Received: by noel.decibel.org (Postfix, from userid 1001) id 9459C56440; Wed, 9 Aug 2006 16:20:46 -0500 (CDT) Received: (hashcash-sendmail, from uid 1001); Wed, 9 Aug 2006 16:20:46 -0500 Date: Wed, 9 Aug 2006 16:20:46 -0500 From: "Jim C. Nasby" To: Eugeny N Dzhurinsky Cc: pgsql-performance@postgresql.org Subject: Re: vacuuming Message-ID: <20060809212045.GT40481@pervasive.com> References: <20060808073956.GA2087@office.redwerk.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20060808073956.GA2087@office.redwerk.com> X-Operating-System: FreeBSD 6.0-RELEASE-p4 amd64 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.11 X-Hashcash: 1:20:060809:bofh@redwerk.com::ROz/1tomwpY15rFp:0325Q X-Hashcash: 1:20:060809:pgsql-performance@postgresql.org::dJ8chrHcvffEgr6S:00000 0000000000000000000000002POF X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.102 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200608/163 X-Sequence-Number: 20348 On Tue, Aug 08, 2006 at 10:39:56AM +0300, Eugeny N Dzhurinsky wrote: > Hello > > I have pg_autovacuum running with the arguments: > > pg_autovacuum -D -s 120 -v 10000 It's been a while since I looked at the pg_autovac settings, but I know that it's threasholds were way, way to high. They were set to something like 2, when 0.2 is a better idea. > the database is postgresql 8.0.0 > > Sometimes load average on server raises to 20 and it is almost impossible to > login via SSH > > When I'm logging in finally, I see there is cpu usage: 6% and iowait 95% > > ps ax | grep post gives me > > postgres: postgres db [local] VACUUM > > Is there some solution to avoid such cases? Have you turned on vacuum_cost_delay? -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461