X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0B5AC9DC86C for ; Mon, 13 Mar 2006 21:56:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 10947-06 for ; Mon, 13 Mar 2006 21:56:10 -0400 (AST) X-Greylist: delayed 00:23:58.670959 by SQLgrey- Received: from frank.wiles.org (frank.wiles.org [24.124.39.75]) by postgresql.org (Postfix) with ESMTP id A52A89DC829 for ; Mon, 13 Mar 2006 21:56:04 -0400 (AST) Received: from kungfu (frank.wiles.org [127.0.0.1]) by frank.wiles.org (8.13.1/8.13.1) with SMTP id k2E1u7i9011333; Mon, 13 Mar 2006 19:56:07 -0600 Date: Mon, 13 Mar 2006 19:57:27 -0600 From: Frank Wiles To: Chris Cc: pgsql-performance@postgresql.org Subject: Re: import performance Message-Id: <20060313195727.78df3adc.frank@wiles.org> In-Reply-To: <44161F7D.9070707@gmail.com> References: <441610EB.7070001@gmail.com> <44161B46.5050801@gmail.com> <20060313193318.61709662.frank@wiles.org> <44161F7D.9070707@gmail.com> X-Mailer: Sylpheed version 2.0.1 (GTK+ 2.6.10; i686-pc-linux-gnu) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.077 required=5 tests=[AWL=0.077] X-Spam-Score: 0.077 X-Spam-Level: X-Archive-Number: 200603/182 X-Sequence-Number: 17619 On Tue, 14 Mar 2006 12:42:21 +1100 Chris wrote: > Different hardware. > > 7.4 is running on a 500MHz computer with 256M compared to 8.1 running > on a 2.6GHz with 512M. Well when it comes to inserts CPU and RAM have almost nothing to do with it. What are the hard disk differences? Does the old server have fast SCSI disk and the new box SATA? Or the old server was on a RAID volume and the new one isn't, etc... those are the sort of hardware differences that are important in this particular case. --------------------------------- Frank Wiles http://www.wiles.org ---------------------------------