From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postgresql on file system EXT2 or EXT3 |
Date: | 2003-11-29 14:06:58 |
Message-ID: | 20031129140657.GA669@libertyrms.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Nov 28, 2003 at 02:46:50PM -0800, Mike Benoit wrote:
> I would be very interested in seeing actual PGBENCH results with
> databases on the different file systems, thats the only way you will
> know for sure which file system is best for the task.
I suspect because of the nature of its workload, in my experience
pg_bench is lousy for measuring filesystem performance: it always
bottlenecks somewhere else.
Chris Browne did some work for us some time ago evaluating XFS, JFS,
and ext3, and concluded that JFS was the best under a high-update
load; that workload was selected precisely because it was I/O bound.
I thought he sent the results to the -performance list, but I can't
put my hands on the email right now. Chris?
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
From | Date | Subject | |
---|---|---|---|
Next Message | Jay O'Connor | 2003-11-29 14:24:29 | Re: Triggers, Stored Procedures, PHP. was: Re: PostgreSQL |
Previous Message | Nigel J. Andrews | 2003-11-29 14:04:06 | Re: PostgreSQL Advocacy, Thoughts and Comments |