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 B6DE69DCB86 for ; Tue, 14 Mar 2006 02:28:36 -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 48772-10 for ; Tue, 14 Mar 2006 02:28:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.201]) by postgresql.org (Postfix) with ESMTP id A8FC69DC890 for ; Tue, 14 Mar 2006 02:28:33 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so1533846nzn for ; Mon, 13 Mar 2006 22:28:34 -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=FWIQHn/y9fztZLMPm/wRbSIWW5yN10Ke9z1VZolq3cgTGMDm43TVkm8wVhKCBGSHtBLzf+tKbCUfQU9zP2EEBUuHoJxrQur+3aTG+4aarwSy1Q/sR3TjIAWj0Hc3y/k8rg0+uJQBRsJKHamnjLTrht8vmYQTFzOFNo4v6L2g+7w= Received: by 10.36.79.18 with SMTP id c18mr1425643nzb; Mon, 13 Mar 2006 22:28:34 -0800 (PST) Received: from ?10.1.1.22? ( [203.217.18.65]) by mx.gmail.com with ESMTP id 7sm2308660nzn.2006.03.13.22.28.32; Mon, 13 Mar 2006 22:28:33 -0800 (PST) Message-ID: <44166292.70708@gmail.com> Date: Tue, 14 Mar 2006 17:28:34 +1100 From: Chris User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: David Lang CC: pgsql-performance@postgresql.org Subject: Re: import performance References: <441610EB.7070001@gmail.com> <44161B46.5050801@gmail.com> <20060313193318.61709662.frank@wiles.org> <44161F7D.9070707@gmail.com> <12028.1142301081@sss.pgh.pa.us> <44162A10.7080205@gmail.com> In-Reply-To: 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/185 X-Sequence-Number: 17622 David Lang wrote: > On Tue, 14 Mar 2006, Chris wrote: > >> The only other thing I can see is the old server is ext2: >> /dev/hda4 on / type ext2 (rw,errors=remount-ro) >> >> the new one is ext3: >> /dev/hda2 on / type ext3 (rw) > > > this is actually a fairly significant difference. > > with ext3 most of your data actually gets written twice, once to the > journal and a second time to the spot on the disk it's actually going to > live. > > in addition there are significant differences in how things are arranged > on disk between the two filesystems, (overridable at mount, but only > changes future new files). the ext3 layout is supposed to be better for > a general purpose filesystem, but I've found common cases (lots of files > and directories) where it's significantly slower, and I think postgres > will fall into those layouts. > > try makeing a xfs filesystem for your postgres data and see what sort of > performance you get on it. Interesting. To be honest I think I'm just lucky with my really old server. I can't see any particular tweaks in regards to drives or anything else. I have another server running postgres 7.4.something and it's as slow as the 8.1 system. #1 is running 2.4.x kernel - pg 7.4 (debian package) - good performance. ext2. #2 is running 2.2.x kernel (I know I know).. - pg 7.4 (debian package) - reasonable performance. ext2. #3 is running 2.6.x kernel - pg 8.1 (fedora package) - reasonable performance. ext3. -- Postgresql & php tutorials http://www.designmagick.com/