What`s wrong with JFS configuration?

From: Paweł Gruszczyński
Subject: What`s wrong with JFS configuration?
Date: ,
Msg-id: 462EFA63.1030306@inea.com.pl
(view: Whole thread, Raw)
Responses: Re: What`s wrong with JFS configuration?  (Heikki Linnakangas)
Re: What`s wrong with JFS configuration?  (Jim Nasby)
List: pgsql-performance

Tree view

What`s wrong with JFS configuration?  (Paweł Gruszczyński, )
 Re: What`s wrong with JFS configuration?  (Heikki Linnakangas, )
  Re: What`s wrong with JFS configuration?  (Dave Cramer, )
 Re: What`s wrong with JFS configuration?  (Paweł Gruszczyński, )
  Re: What`s wrong with JFS configuration?  (Greg Smith, )
 Re: What`s wrong with JFS configuration?  (Chris Browne, )
 Re: What`s wrong with JFS configuration?  (Jim Nasby, )
  Re: What`s wrong with JFS configuration?  (Cosimo Streppone, )
 Re: What`s wrong with JFS configuration?  ("Luke Lonergan", )
 Re: What`s wrong with JFS configuration?  (Jim Nasby, )

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


pgsql-performance by date:

From: Dave Cramer
Date:
Subject: Re: What`s wrong with JFS configuration?
From: Paweł Gruszczyński
Date:
Subject: Re: What`s wrong with JFS configuration?