Re: [GENERAL] Performance while loading data and indexing

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Greg Copeland <greg(at)CopelandConsulting(dot)Net>
Cc: Mike Benoit <mikeb(at)netnation(dot)com>, PostgresSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [GENERAL] Performance while loading data and indexing
Date: 2002-10-03 23:59:56
Message-ID: 200210032359.g93NxuZ07976@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers pgsql-performance

Greg Copeland wrote:
-- Start of PGP signed section.
> Hey, excellent. Thanks!
>
> Based on that, it appears that XFS is a pretty good FS to use. For me,
> the real surprise was how well reiserfs performed.
>

OK, hardware performance paper updated:

---------------------------------------------------------------------------

File system choice is particularly difficult on Linux because there are
so many file system choices, and none of them are optimal: ext2 is not
entirely crash-safe, ext3, xfs, and jfs are journal-based, and Reiser is
optimized for small files and does journalling. The journalling file
systems can be significantly slower than ext2 but when crash recovery is
required, ext2 isn't an option. If ext2 must be used, mount it with sync
enabled. Some people recommend xfs or an ext3 filesystem mounted with
data=writeback.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-10-04 00:41:58 Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
Previous Message Andrew Sullivan 2002-10-03 23:58:39 Re: [SQL] [GENERAL] CURRENT_TIMESTAMP

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-10-04 00:41:58 Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
Previous Message Andrew Sullivan 2002-10-03 23:58:39 Re: [SQL] [GENERAL] CURRENT_TIMESTAMP

Browse pgsql-performance by date

  From Date Subject
Next Message Shridhar Daithankar 2002-10-04 08:00:54 Re: [HACKERS] Large databases, performance
Previous Message Greg Copeland 2002-10-03 23:35:34 Re: [GENERAL] Performance while loading data and indexing