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 235C99DCDBB for ; Mon, 13 Mar 2006 21:42:20 -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 09070-06 for ; Mon, 13 Mar 2006 21:42:23 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.198]) by postgresql.org (Postfix) with ESMTP id 7D48E9DCDBC for ; Mon, 13 Mar 2006 21:42:17 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so1488740nzn for ; Mon, 13 Mar 2006 17:42:21 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:cc:subject:references:in-reply-to:content-type:content-transfer-encoding; b=Npb3adMDy+7GIxj2J6QyAZzRrA9LW2Er+oxJgjQz64llurBWcoIXYc4kEWd++ortg6CNIZsDOEtxB7E0xn2XPbEwci0zFSmWe87H6iOmwcNDdL6JQZwEUQJhtsIDZL+2HpdVKCs3LuD2bHTymNB06MUk0Px/CXIvQ98xiRUDqx8= Received: by 10.36.24.12 with SMTP id 12mr3423045nzx; Mon, 13 Mar 2006 17:42:21 -0800 (PST) Received: from ?10.1.1.22? ( [203.217.18.65]) by mx.gmail.com with ESMTP id 17sm2027385nzo.2006.03.13.17.42.20; Mon, 13 Mar 2006 17:42:21 -0800 (PST) Message-ID: <44161F7D.9070707@gmail.com> Date: Tue, 14 Mar 2006 12:42:21 +1100 From: Chris User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Frank Wiles CC: pgsql-performance@postgresql.org Subject: Re: import performance References: <441610EB.7070001@gmail.com> <44161B46.5050801@gmail.com> <20060313193318.61709662.frank@wiles.org> In-Reply-To: <20060313193318.61709662.frank@wiles.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.118 required=5 tests=[AWL=0.118] X-Spam-Score: 0.118 X-Spam-Level: X-Archive-Number: 200603/180 X-Sequence-Number: 17617 Frank Wiles wrote: > 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? Different hardware. 7.4 is running on a 500MHz computer with 256M compared to 8.1 running on a 2.6GHz with 512M. The only notable config variables on that machine (the rest are logging): commit_delay = 10000 checkpoint_segments = 10 checkpoint_warning = 300 insert times: Time: 63.756 ms INSERT 13584074 1 Time: 46.465 ms INSERT 13584075 1 Time: 70.518 ms INSERT 13584077 1 Time: 59.864 ms INSERT 13584078 1 Time: 35.984 ms Tons of difference :/ -- Postgresql & php tutorials http://www.designmagick.com/