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 5633AD1B4F2 for ; Fri, 17 Oct 2003 23:37:44 +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 49529-03 for ; Fri, 17 Oct 2003 20:37:16 -0300 (ADT) Received: from jump.bivio.com (jump.bivio.com [216.87.82.232]) by svr1.postgresql.org (Postfix) with ESMTP id 1FC19D1B4E3 for ; Fri, 17 Oct 2003 20:37:13 -0300 (ADT) Received: (from nagler@localhost) by jump.bivio.com (8.11.6/8.11.6) id h9HNbGj06790; Fri, 17 Oct 2003 17:37:16 -0600 X-Authentication-Warning: jump.bivio.com: nagler set sender to nagler@bivio.biz using -f From: Rob Nagler MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-ID: <16272.32044.80671.948532@jump.bivio.com> Date: Fri, 17 Oct 2003 17:37:16 -0600 To: pgsql-performance@postgresql.org Subject: Re: vacuum locking In-Reply-To: <200310170936.25997.josh@agliodbs.com> References: <16272.318.870000.93584@gargle.gargle.HOWL> <3F9006BF.40906@persistent.co.in> <16272.4154.489000.227676@gargle.gargle.HOWL> <200310170936.25997.josh@agliodbs.com> X-Mailer: VM 6.96 under Emacs 20.7.1 Organization: bivio Software Artisans, Inc. X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/488 X-Sequence-Number: 4236 Josh Berkus writes: > Yes, but it will have less of an impact on the system while it's running. We'll find out. I lowered it to vacuum_mem to 32000. > What sort of disk array do you have? That seems like a lot of time > considering how little work VACUUM is doing. Vendor: DELL Model: PERCRAID Mirror Rev: V1.0 Type: Direct-Access ANSI SCSI revision: 02 Two 10K disks attached. Rob