pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: Kaarel <kaarel@future.ee>
Cc: Grega Bremec <gregab@noviforum.si>
Cc: Performance <pgsql-performance@postgresql.org>
Subject: Re: Linux filesystem shootout
Date: Thu, 09 Oct 2003 20:36:51 +0530
Message-ID: <3F85798B.1010106@persistent.co.in> (raw)
In-Reply-To: <3F85763C.3080307@future.ee>
References: <3F8542B5.6070209@persistent.co.in>
	<20031009121124.GA7038@elbereth.noviforum.si>
	<3F85763C.3080307@future.ee>

Kaarel wrote:
>>>http://www.ussg.iu.edu/hypermail/linux/kernel/0310.1/0208.html
>>>
>>>Shridhar
>>>    
>>>
> I feel incompetent when it comes to file systems. Yet everybody would like to 
> have the best file system if given the choice...so do I :) Here I am looking at 
> those tables seeing JFS having more green cells than others. The more green the 
> better right? So based on these tests JFS ought to be the one?

Yes and no. Yes for the results. No for the tests that weren't run.

Database load is quite different. Its mixture of read and write load with a 
dynamics varying from one extreme to other, between these two.

All it says that if you want to choose a good file system for postgresql, look 
at JFS first..:-)

  Besides all the tests were done on files file bigger than 1GB. If single file 
size is restricted to 1GB, it might produce a different result set. And 
postgresql does not exceed 1GB limit per file.

So still, quite a few unknowns there..

Best thing could be repeat those benchmarks on $PGDATA with your live data 
inside it. It could mimmic the load pretty well..

  Shridhar




view thread (8+ messages)  latest in thread

Message-ID: <3F85798B.1010106@persistent.co.in>
Permalink:  ../3F85798B.1010106@persistent.co.in/
Also on:    postgresql.org/message-id/3F85798B.1010106@persistent.co.in

 · 

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, kaarel@future.ee, gregab@noviforum.si
  Subject: Re: Linux filesystem shootout
  In-Reply-To: <3F85798B.1010106@persistent.co.in>

* 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