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 322559DC85A for ; Mon, 13 Mar 2006 21:32:10 -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 08014-04 for ; Mon, 13 Mar 2006 21:32:13 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id B02959DC855 for ; Mon, 13 Mar 2006 21:32:07 -0400 (AST) Received: from frank.wiles.org (frank.wiles.org [24.124.39.75]) by svr4.postgresql.org (Postfix) with ESMTP id 2A3115AF024 for ; Tue, 14 Mar 2006 01:32:11 +0000 (GMT) Received: from kungfu (frank.wiles.org [127.0.0.1]) by frank.wiles.org (8.13.1/8.13.1) with SMTP id k2E1VwfO011223; Mon, 13 Mar 2006 19:31:58 -0600 Date: Mon, 13 Mar 2006 19:33:18 -0600 From: Frank Wiles To: Chris Cc: swm@alcove.com.au, pgsql-performance@postgresql.org Subject: Re: import performance Message-Id: <20060313193318.61709662.frank@wiles.org> In-Reply-To: <44161B46.5050801@gmail.com> References: <441610EB.7070001@gmail.com> <44161B46.5050801@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.074 required=5 tests=[AWL=0.074] X-Spam-Score: 0.074 X-Spam-Level: X-Archive-Number: 200603/179 X-Sequence-Number: 17616 On Tue, 14 Mar 2006 12:24:22 +1100 Chris wrote: > Gavin Sherry wrote: > > On Tue, 14 Mar 2006, Chris wrote: > > > > > >>Hi all, > >> > >>I'm trying to work out why my 8.1 system is slower than my 7.4 > >>system for importing data. > >> > >>The import is a lot of "insert into" commands - it's a converted > >>database from another system so I can't change it to copy commands. Are you on the same hardware specifically in your disk subsystem? Anything else different about how the two servers are used? --------------------------------- Frank Wiles http://www.wiles.org ---------------------------------