Re: JFS fastest filesystem for PostgreSQL? - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: JFS fastest filesystem for PostgreSQL?
Date
Msg-id 42D6B0D6.6000101@commandprompt.com
Whole thread Raw
In response to Re: JFS fastest filesystem for PostgreSQL?  ("Jim C. Nasby" <decibel@decibel.org>)
List pgsql-performance
>>I ran pgbench with a scale factor of 1000 and a total of 100,000
>>transactions per run.  I varied the number of clients between 10 and
>>100.  It appears from my test JFS is much faster than both ext3 and XFS
>>for this workload.  JFS and XFS were made with the mkfs defaults.  ext3
>>was made with -T largefile4 and -E stride=32.  The deadline scheduler
>>was used for all runs (anticipatory scheduler is much worse).
>>
>>Here's the result, in transactions per second.
>>
>>              ext3  jfs  xfs
>>-----------------------------
>> 10 Clients     55   81   68
>>100 Clients     61  100   64
>>----------------------------

I would be curious as to what options were passed to jfs and xfs.

Sincerely,

Joshua D. Drake


>
>
> BTW, it'd be interesting to see how UFS on FreeBSD compared.


--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

pgsql-performance by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: JFS fastest filesystem for PostgreSQL?
Next
From: Greg Stark
Date:
Subject: Re: Quad Opteron stuck in the mud