X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0D149D1B53E for ; Fri, 17 Oct 2003 16:37:07 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75279-09 for ; Fri, 17 Oct 2003 13:36:35 -0300 (ADT) Received: from davinci.ethosmedia.com (unknown [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id E99A2D1B53C for ; Fri, 17 Oct 2003 13:36:34 -0300 (ADT) Received: from [63.195.55.98] (HELO spooky) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 3780459; Fri, 17 Oct 2003 09:37:12 -0700 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: Rob Nagler , pgsql-performance@postgresql.org Subject: Re: vacuum locking Date: Fri, 17 Oct 2003 09:36:25 -0700 User-Agent: KMail/1.4.3 References: <16272.318.870000.93584@gargle.gargle.HOWL> <3F9006BF.40906@persistent.co.in> <16272.4154.489000.227676@gargle.gargle.HOWL> In-Reply-To: <16272.4154.489000.227676@gargle.gargle.HOWL> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <200310170936.25997.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/483 X-Sequence-Number: 4231 Rob, > vacuum_mem might be slowing down the system? But if I reduce it, > won't vacuuming get slower? Yes, but it will have less of an impact on the system while it's running. > INFO: Removed 8368 tuples in 427 pages. > CPU 0.06s/0.04u sec elapsed 1.54 sec. > INFO: Pages 24675: Changed 195, Empty 0; Tup 1031519: Vac 8368, Keep 254, > UnUsed 1739. Total CPU 2.92s/2.58u sec elapsed 65.35 sec. > > INFO: Removed 232 tuples in 108 pages. > CPU 0.01s/0.02u sec elapsed 0.27 sec. > INFO: Pages 74836: Changed 157, Empty 0; Tup 4716475: Vac 232, Keep 11, > UnUsed 641. > Total CPU 10.19s/6.03u sec elapsed 261.44 sec. What sort of disk array do you have? That seems like a lot of time considering how little work VACUUM is doing. -- Josh Berkus Aglio Database Solutions San Francisco