Re: [GENERAL] Performance while loading data and indexing - Mailing list pgsql-hackers

From Greg Copeland
Subject Re: [GENERAL] Performance while loading data and indexing
Date
Msg-id 1033074232.23474.42.camel@mouse.copelandconsulting.net
Whole thread Raw
In response to Re: [GENERAL] Performance while loading data and indexing  (Hans-Jürgen Schönig <postgres@cybertec.at>)
List pgsql-hackers
I tend to agree with this though I have nothing to back up it with.  My
impression is that XFS does very well for large files.  Accepting that
as fact?, my impression is that XFS historically does well for
database's.  Again, I have nothing to back that up other than hear-say
and conjecture.

Greg


On Thu, 2002-09-26 at 15:55, Hans-Jürgen Schönig wrote:
> I have seen various benchmarks where XFS seems to perform best when it
> comes to huge amounts of data and many files (due to balanced internal
> b+ trees).
> also, XFS seems to be VERY mature and very stable.
> ext2/3 don't seem to be that fast in most of the benchmarks.
>
> i did some testing with reiser some time ago. the problem is that it
> seems to restore a very historic consistent snapshot of the data. XFS
> seems to be much better in this respect.
>
> i have not tested JFS yet (but on this damn AIX beside me)
> from my point of view i strongly recommend XFS (maybe somebody from
> RedHat should think about it).
>
>     Hans
>
>
> Neil Conway wrote:
>
> >Bruce Momjian <pgman@candle.pha.pa.us> writes:
> >
> >
> >>The paper does recommend ext3, but the differences between file systems
> >>are very small.
> >>
> >>
> >
> >Well, I only did a very rough benchmark (a few runs of pgbench), but
> >the results I found were drastically different: ext2 was significantly
> >faster (~50%) than ext3-writeback, which was in turn significantly
> >faster (~25%) than ext3-ordered.
> >
> >
> >
> >>Also, though ext3 is slower, turning fsync off should make ext3 function
> >>similar to ext2.
> >>
> >>
> >
> >Why would that be?
> >
> >Cheers,
> >
> >Neil
> >
> >
> >
>
>
> --
> *Cybertec Geschwinde u Schoenig*
> Ludo-Hartmannplatz 1/14, A-1160 Vienna, Austria
> Tel: +43/1/913 68 09; +43/664/233 90 75
> www.postgresql.at <http://www.postgresql.at>, cluster.postgresql.at
> <http://cluster.postgresql.at>, www.cybertec.at
> <http://www.cybertec.at>, kernel.cybertec.at <http://kernel.cybertec.at>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: [GENERAL] Performance while loading data and indexing
Next
From: Bruce Momjian
Date:
Subject: Re: [GENERAL] Performance while loading data and indexing