Re: JFS fastest filesystem for PostgreSQL?

>>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/