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
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