From: Chris <dmagick@gmail.com>
To: David Lang <david@lang.hm>
Cc: pgsql-performance@postgresql.org
Subject: Re: import performance
Date: Tue, 14 Mar 2006 17:28:34 +1100
Message-ID: <44166292.70708@gmail.com> (raw)
In-Reply-To: <Pine.LNX.4.62.0603132210440.23148@qnivq.ynat.uz>
References: <441610EB.7070001@gmail.com>
<Pine.LNX.4.58.0603141146130.16333@linuxworld.com.au>
<44161B46.5050801@gmail.com>
<20060313193318.61709662.frank@wiles.org>
<44161F7D.9070707@gmail.com>
<12028.1142301081@sss.pgh.pa.us>
<44162A10.7080205@gmail.com>
<Pine.LNX.4.62.0603132210440.23148@qnivq.ynat.uz>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dmagick@gmail.com, david@lang.hm
Subject: Re: import performance
In-Reply-To: <44166292.70708@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox