Re: What filesystem? - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: What filesystem?
Date
Msg-id 200302231231.43240.shridhar_daithankar@persistent.co.in
Whole thread Raw
In response to Re: What filesystem?  (Neil Conway <neilc@samurai.com>)
Responses Re: What filesystem?  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-general
On Saturday 22 Feb 2003 11:41 pm, you wrote:
> On Sat, 2003-02-22 at 00:25, Joshua Drake wrote:
> >  JFS and XFS are the most thoroughly tested. EXT2 is the slowest but
> > very very stable. ReiserFS is good, EXT3 is good as long as you are
> > running 2.4.20 + the source EXT3 patches.
>
> I'd be quite surprised if ext2 was any slower than ext3. Also, since
> most PostgreSQL disk I/O involves large files, I wouldn't think ReiserFS
> would outperform ext2 either.

It does. By quite a large margin. I don't remember exactly but it can be
between 30%-60% on single IDE drive.

Apparently tree indexes in reiser helps it a lot.

 Shridhar

pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: GROUPing problem
Next
From: "erwan ancel"
Date:
Subject: troubles with postgresql