From: Jeffrey W. Baker <jwbaker@acm.org>
To: pgsql-users@postgresql.org
Subject: JFS fastest filesystem for PostgreSQL?
Date: Wed, 13 Jul 2005 17:20:15 -0700
Message-ID: <1121300415.20950.33.camel@toonses.gghcwest.com> (raw)
I just took delivery of a new system, and used the opportunity to
benchmark postgresql 8.0 performance on various filesystems. The system
in question runs Linux 2.6.12, has one CPU and 1GB of system memory, and
5 7200RPM SATA disks attached to an Areca hardware RAID controller
having 128MB of cache. The caches are all write-back.
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
----------------------------
-jwb
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: jwbaker@acm.org, pgsql-users@postgresql.org
Subject: Re: JFS fastest filesystem for PostgreSQL?
In-Reply-To: <1121300415.20950.33.camel@toonses.gghcwest.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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