pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: evgeny gridasov <eugrid@fpm.kubsu.ru>
To: pgsql-performance@postgresql.org
Subject: Re: RAID Stripe size
Date: Tue, 20 Sep 2005 20:02:10 +0400
Message-ID: <20050920200210.27ad75cf.eugrid@fpm.kubsu.ru> (raw)
In-Reply-To: <A209FE4DA934614CAF3F5BD8E5E14290B0DD8D@ex2k.bankofamerica.com>
References: <A209FE4DA934614CAF3F5BD8E5E14290B0DD8D@ex2k.bankofamerica.com>

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



view thread (10+ messages)

Message-ID: <20050920200210.27ad75cf.eugrid@fpm.kubsu.ru>
Permalink:  ../20050920200210.27ad75cf.eugrid@fpm.kubsu.ru/
Also on:    postgresql.org/message-id/20050920200210.27ad75cf.eugrid@fpm.kubsu.ru

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: eugrid@fpm.kubsu.ru
  Subject: Re: RAID Stripe size
  In-Reply-To: <20050920200210.27ad75cf.eugrid@fpm.kubsu.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox