X-Original-To: pgsql-performance@postgresql.org Received: from davinci.ethosmedia.com (unknown [209.10.40.251]) by postgresql.org (Postfix) with ESMTP id DFF554762E1 for ; Wed, 5 Mar 2003 16:11:28 -0500 (EST) Received: from [216.135.165.74] (HELO lazarus) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.0.2) with ESMTP-TLS id 2881705; Wed, 05 Mar 2003 13:11:09 -0800 Content-Type: text/plain; charset="iso-8859-1" From: Josh Berkus Organization: Aglio Database Solutions To: "Tim Mohler" , Subject: Re: Batch copying of databases Date: Wed, 5 Mar 2003 11:37:39 -0800 User-Agent: KMail/1.4.3 References: In-Reply-To: MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200303051137.39517.josh@agliodbs.com> X-Archive-Number: 200303/36 X-Sequence-Number: 1334 Tim, > I'm new to Postgres, and am not even the DBA for the system. I'm just a > sysadmin trying to make things run faster. Every month, we copy over a 25 > million row table from the production server to the reporting server. Tot= al > size is something like 40 gigabytes. Are you doing this through COPY files, or some other means? --=20 Josh Berkus josh@agliodbs.com Aglio Database Solutions San Francisco