Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] Performance while loading data and indexing

From: Greg Copeland <greg(at)CopelandConsulting(dot)Net>
To: hs(at)cybertec(dot)at
Cc: PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] Performance while loading data and indexing
Date: 2002-09-26 21:03:51
Message-ID: 1033074232.23474.42.camel@mouse.copelandconsulting.net (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-hackerspgsql-performance
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(at)candle(dot)pha(dot)pa(dot)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(at)postgresql(dot)org

In response to

pgsql-performance by date

Next:From: James MaesDate: 2002-09-26 21:06:07
Subject: Re: [GENERAL] Performance while loading data and indexing
Previous:From: Neil ConwayDate: 2002-09-26 21:03:26
Subject: Re: [HACKERS] Performance while loading data and indexing

pgsql-hackers by date

Next:From: James MaesDate: 2002-09-26 21:06:07
Subject: Re: [GENERAL] Performance while loading data and indexing
Previous:From: Neil ConwayDate: 2002-09-26 21:03:26
Subject: Re: [HACKERS] Performance while loading data and indexing

pgsql-general by date

Next:From: James MaesDate: 2002-09-26 21:06:07
Subject: Re: [GENERAL] Performance while loading data and indexing
Previous:From: Neil ConwayDate: 2002-09-26 21:03:26
Subject: Re: [HACKERS] Performance while loading data and indexing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group