pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: pgsql-performance@postgresql.org
Subject: Re: Tuning PostgreSQL
Date: Mon, 21 Jul 2003 16:01:41 +0530
Message-ID: <3F1C0E65.27609.14A7BA43@localhost> (raw)
In-Reply-To: <3F1BBBD3.6070405@bytecraft.com.my>
References: <3F1C00B2.20319.147235A4@localhost>

On 21 Jul 2003 at 18:09, Ang Chin Han wrote:

> Shridhar Daithankar wrote:
> > On 21 Jul 2003 at 11:23, Alexander Priem wrote:
> 
> >>I use ext3 filesystem, which probably is not the best performer, is it?
> > 
> > No. You also need to check ext2, reiser and XFS. There is no agreement between 
> > users as in what works best. You need to benchmark and decide.
> 
> Need? Maybe I'm a bit disillusioned, but are the performances between 
> the filesystems differ so much as to warrant the additional effort? 
> (e.g. XFS doesn't come with Red Hat 9 -- you'll have to patch the 
> source, and compile it yourself).

Well, the benchmarking is not to prove which filesystem is fastest and feature 
rich but to find out which one suits your needs best.
 
> Benchmarking it properly before deployment is tough: are the test load 
> on the db/fs representative of actual load? Is 0.5% reduction in CPU 
> usage worth it? Did you test for catastrophic failure by pulling the 
> plug during write operations (ext2) to test if the fs can handle it? Is 
> the code base for the particular fs stable enough? Obscure bugs in the fs?

Well, that is what that 'benchmark' is supposed to find out. Call it pre-
deployment testing or whatever other fancy name one sees fit. But it is a must 
in almost all serious usage.
 
> For the record, we tried several filesystems, but stuck with 2.4.9's 
> ext3 (Red Hat Advanced Server). Didn't hit a load high enough for the 
> filesystem choices to matter after all. :(

Good for you. You have time at hand to find out which one suits you best. Do 
the testing before you have load that needs another FS..:-)

Bye
 Shridhar

--
It would be illogical to assume that all conditions remain stable.		-- Spock, "The Enterprise" Incident", stardate 5027.3




view thread (47+ messages)  latest in thread

Message-ID: <3F1C0E65.27609.14A7BA43@localhost>
Permalink:  ../3F1C0E65.27609.14A7BA43@localhost/
Also on:    postgresql.org/message-id/3F1C0E65.27609.14A7BA43@localhost

 · 

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: shridhar_daithankar@persistent.co.in
  Subject: Re: Tuning PostgreSQL
  In-Reply-To: <3F1C0E65.27609.14A7BA43@localhost>

* 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