What`s wrong with JFS configuration?

From: Paweł Gruszczyński <pawel(dot)gruszczynski(at)inea(dot)com(dot)pl>
To: pgsql-performance(at)postgresql(dot)org
Subject: What`s wrong with JFS configuration?
Date: 2007-04-25 06:51:15
Message-ID: 462EFA63.1030306@inea.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hello!

I have strange situation. I`m testing performance of PostgreSQL database
at different filesystems (ext2,ex3,jfs) and I cant say that JFS is as
much faster as it is said.
My test look`s like that:

Server: 2 x Xeon 2,4GHz 2GB ram 8 x HDD SCSI configured in RAID arrays
like that:

Unit UnitType Status %Cmpl Stripe Size(GB) Cache AVerify
IgnECC
------------------------------------------------------------------------------
u0 RAID-10 OK - 64K 467.522 ON - -
u6 RAID-1 OK - - 298.09 ON - -

Port Status Unit Size Blocks Serial
---------------------------------------------------------------
p0 OK u0 233.76 GB 490234752 Y634Y1DE
p1 OK u0 233.76 GB 490234752 Y636TR9E
p2 OK u0 233.76 GB 490234752 Y64VZF1E
p3 OK u0 233.76 GB 490234752 Y64G8HRE
p4 NOT-PRESENT - - - -
p5 OK - 233.76 GB 490234752 Y63YMSNE
p6 OK u6 298.09 GB 625142448 3QF08HFF
p7 OK u6 298.09 GB 625142448 3QF08HHW

where u6 stores Fedora Core 6 operating system, and u0 stores 3
partitions with ext2, ext3 and jfs filesystem.
Postgresql 8.2 engine is intalled at system partition (u6 in raid) and
run with data directory at diffrent FS partition for particular test.
To test I use pgBench with default database schema, run for 25, 50, 75
users at one time. Every test I run 5 time to take average.
Unfortunetly my result shows that ext is fastest, ext3 and jfs are very
simillar. I can understand that ext2 without jurnaling is faster than
ext3, it is said that jfs is 40 - 60% faster. I cant see the difference.
Part of My results: (transaction type | scaling factor | num of clients
| tpl | num on transactions | tps including connection time | tps
excliding connection time)

EXT2:

TPC-B (sort of),50,75,13,975|975,338.286682,358.855582
TPC-B (sort of),50,75,133,9975|9975,126.777438,127.023687
TPC-B (sort of),50,75,1333,99975|99975,125.612325,125.636193

EXT3:

TPC-B (sort of),50,75,13,975|975,226.139237,244.619009
TPC-B (sort of),50,75,133,9975|9975,88.678922,88.935371
TPC-B (sort of),50,75,1333,99975|99975,79.126892,79.147423

JFS:

TPC-B (sort of),50,75,13,975|975,235.626369,255.863271
TPC-B (sort of),50,75,133,9975|9975,88.408323,88.664584
TPC-B (sort of),50,75,1333,99975|99975,81.003394,81.024297

Can anyone tell me what`s wrong with my test? Or maybe it is normal?

Pawel Gruszczynski

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2007-04-25 08:54:12 Re: What`s wrong with JFS configuration?
Previous Message zardozrocks 2007-04-24 21:26:46 Simple query, 10 million records...MySQL ten times faster