pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Rodrigo Filgueira <rfilgue@cinterfor.org.uy>
To: Frank Hsueh <frank.hsueh@gmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: to fsync or not to fsync (ext3?)
Date: Tue, 06 Jul 2004 13:43:14 -0300
Message-ID: <40EAD6A2.9030400@cinterfor.org.uy> (raw)
In-Reply-To: <753644204070608452ac91892@mail.gmail.com>
References: <40EABDEF.3090607@cinterfor.org.uy>
	<753644204070608452ac91892@mail.gmail.com>

Frank, thanks for your answer,

This article http://www.linuxjournal.com/print.php?sid=5841 evaluates 
performance from a relational database point of view and it concludes 
that ext3 is faster.
The articles you provided evaluate filesystems by using basic shell 
commands, copy, tar, touch.
I really don't know why ext3 would be faster for databases but here are 
some tests that suggest this is true,

I run pgbench with data=writeback for ext3, this is as ext2 as an ext3 
fs can get, and results are more or less the same as with data=journal

Best run with data=journal
------------------------------------

[root@dbs pgbench]# ./pgbench -U dba -P 4ghinec osdb -c 10 -s 11 -t 1000
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 10
number of transactions per client: 1000
number of transactions actually processed: 10000/10000
tps = 349.844978 (including connections establishing)
tps = 350.715286 (excluding connections establishing)


Best run with data=writeback
----------------------------------------

[root@dbs pgbench]# ./pgbench -U dba -P 4ghinec osdb -c 10 -s 11 -t 1000
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 1
number of clients: 10
number of transactions per client: 1000
number of transactions actually processed: 10000/10000
tps = 319.239210 (including connections establishing)
tps = 319.961564 (excluding connections establishing)

anybody else can throw some light on this?


Frank Hsueh wrote:

>Rodrigo,
>  
>
>>Hello there, I'm trying to make sure my postgres 7.4 is running as fast
>>as it can in my box.
>>    
>>
>>My Software config is:
>>
>>RedHat 7.3 - 2.4.20-28.7smp Kernel, reporting four processors because of
>>hyper threading.
>>Postgres 7.4
>>Data directory is on a ext3 journaled filesystem (data=journal)
>>    
>>
>Isn't ext3 a really slow journaled filesystem [1, 2] to begin with?
>
>[1] http://slashdot.org/article.pl?sid=04/05/11/134214
>[2] http://209.81.41.149/~jpiszcz/index.html
>
>It might be a good experiment to figure out how different file systems
>affect perf.
>  
>
 
Rodrigo Filgueira Prates
IT@CINTERFOR/OIT
http://www.cinterfor.org.uy





Message-ID: <40EAD6A2.9030400@cinterfor.org.uy>
Permalink:  ../40EAD6A2.9030400@cinterfor.org.uy/
Also on:    postgresql.org/message-id/40EAD6A2.9030400@cinterfor.org.uy

 · 

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: rfilgue@cinterfor.org.uy, frank.hsueh@gmail.com
  Subject: Re: to fsync or not to fsync (ext3?)
  In-Reply-To: <40EAD6A2.9030400@cinterfor.org.uy>

* 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