Re: RAID Stripe size - Mailing list pgsql-performance

From evgeny gridasov
Subject Re: RAID Stripe size
Date
Msg-id 20050920200210.27ad75cf.eugrid@fpm.kubsu.ru
Whole thread Raw
In response to Re: RAID Stripe size  ("Welty, Richard" <richard.welty@bankofamerica.com>)
Responses Planner statistics vs. count(*)
List pgsql-performance
We have a production server(8.0.2) running 24x7, 300k+ transactions per day.
Linux 2.6.11 / JFS file system.
No problems. It works faster than ext3.

> Alex Turner  wrote:
>
> > I would also recommend looking at file system.  For us JFS worked signifcantly
> >  faster than resier for large read loads and large write loads, so we chose JFS
> >  over ext3 and reiser.
>
> has jfs been reliable for you? there seems to be a lot of conjecture about instability,
> but i find jfs a potentially attractive alternative for a number of reasons.
>
> richard
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match


--
Evgeny Gridasov
Software Developer
I-Free, Russia

pgsql-performance by date:

Previous
From: Alex Turner
Date:
Subject: Re: Need for speed 2
Next
From: evgeny gridasov
Date:
Subject: Planner statistics vs. count(*)