X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id DA417D1B49B for ; Thu, 4 Dec 2003 18:17:37 +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 88924-03 for ; Thu, 4 Dec 2003 14:17:07 -0400 (AST) Received: from davinci.ethosmedia.com (server228.ethosmedia.com [209.128.84.228]) by svr1.postgresql.org (Postfix) with ESMTP id C8DC2D1B444 for ; Thu, 4 Dec 2003 14:17:05 -0400 (AST) Received: from [66.219.92.2] (HELO temoku) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP id 4022445; Thu, 04 Dec 2003 10:17:55 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: "scott.marlowe" , Jack Coates Subject: Re: tuning questions Date: Thu, 4 Dec 2003 10:03:52 -0800 User-Agent: KMail/1.4.3 Cc: References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200312041003.52985.josh@agliodbs.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200312/81 X-Sequence-Number: 4941 Scott, > Just to add to what the others have said here, you probably want to run= =20 > the pg_autovacuum daemon in the background. It comes with 7.4 but will= =20 > work fine with 7.3.=20=20 I don't recommend using pg_autovacuum with a data transformation task. pg= _av=20 is designed for "regular use" not huge batch tasks. --=20 -Josh Berkus Aglio Database Solutions San Francisco