From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
Cc: | "Shridhar Daithankar<shridhar_daithankar(at)persistent(dot)co(dot)in>" <shridhar_daithankar(at)persistent(dot)co(dot)in>, PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: What filesystem? |
Date: | 2003-03-06 15:56:22 |
Message-ID: | 200303061556.h26FuNO28016@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
See my PDF on hardware tuning in the File System section:
http://candle.pha.pa.us/main/writings/pgsql/performance.pdf
The report that Reiser is faster than other file systems for PostgreSQL
doesn't match other reports I have gotten.
---------------------------------------------------------------------------
scott.marlowe wrote:
> On Sun, 23 Feb 2003, Shridhar Daithankar<shridhar_daithankar(at)persistent(dot)co(dot)in> wrote:
>
> > 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.
>
> This is especially true in file systems with lots of small to medium
> files.
>
> For large smaller directory structures, ext2 is pretty good, but fades as
> your fs grows.
>
> As for XFS on linux, I'd guess it's probably pretty good, seeing as how
> IRIX isn't available for the newest beast from SGI, the Altix which is
> their up tp 64 way linux box. SGI is way more dedicated to Linux than
> most people realize.
>
> A couple years ago when their linux port of xfs was still beta I watched a
> guy in a booth demoing it at a linux con and it was amazing. Truly
> amazing.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
--
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
From | Date | Subject | |
---|---|---|---|
Next Message | greg | 2003-03-06 15:59:33 | Re: sub select madness |
Previous Message | Antti Haapala | 2003-03-06 15:50:38 | Re: Shell Commands |