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

From Bruce Momjian
Subject Re: [GENERAL] Performance while loading data and indexing
Date
Msg-id 200210032359.g93NxuZ07976@candle.pha.pa.us
Whole thread Raw
In response to Re: [GENERAL] Performance while loading data and indexing  (Greg Copeland <greg@CopelandConsulting.Net>)
List pgsql-hackers
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@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


pgsql-hackers by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: [SQL] [GENERAL] CURRENT_TIMESTAMP
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] [GENERAL] CURRENT_TIMESTAMP