pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
to fsync or not to fsync
2+ messages / 2 participants
[nested] [flat]

* to fsync or not to fsync
@ 2004-07-06 14:57 Rodrigo Filgueira <rfilgue@cinterfor.org.uy>
  2004-07-06 15:45 ` Re: to fsync or not to fsync Frank Hsueh <frank.hsueh@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Rodrigo Filgueira @ 2004-07-06 14:57 UTC (permalink / raw)
  To: pgsql-performance

Hello there, I'm trying to make sure my postgres 7.4 is running as fast 
as it can in my box.
My hardware configuration is:

HP ML-350G3
Dup processor XEON 2.8
Three U320, 10000 rpm disks, RAID-5
HP 641 Raid Controller.
1GB RAM

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)
Log directory is on another partition.
It is to be a dedicated to databases server, this means there are no 
other heavy processes running.

My tests with pgbench with fsync turned off:

[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 = 408.520028 (including connections establishing)
tps = 409.697088 (excluding connections establishing)


with fsync turned on:

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

I did a lot of these tests and results are consistent. Now then, without 
fsync on I get a
1000% improvment!!!!

Questions now:

1) since I'm using ext3 with data=journal, do I need to use fsync=true?
2) Is there not a problem with RedHat? should fsyncs asked by postgres 
to redhat be such a burden?
3) Any other tests you would suggest me to do?

thank you all

Rodrigo Filgueira Prates
IT@CINTERFOR/OIT
http://www.cinterfor.org.uy





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: to fsync or not to fsync
  2004-07-06 14:57 to fsync or not to fsync Rodrigo Filgueira <rfilgue@cinterfor.org.uy>
@ 2004-07-06 15:45 ` Frank Hsueh <frank.hsueh@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Frank Hsueh @ 2004-07-06 15:45 UTC (permalink / raw)
  To: Rodrigo Filgueira <rfilgue@cinterfor.org.uy>; +Cc: pgsql-performance

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.

-- 
Frank Hsueh, EngSci Elec 0T3 + 1

email: frank.hsueh@gmail.com



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-07-06 15:45 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-06 14:57 to fsync or not to fsync Rodrigo Filgueira <rfilgue@cinterfor.org.uy>
2004-07-06 15:45 ` Frank Hsueh <frank.hsueh@gmail.com>

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