Re: Some pgbench results

From: Jim Nasby <jnasby(at)pervasive(dot)com>
To: Just Someone <just(dot)some(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Some pgbench results
Date: 2006-03-23 17:56:01
Message-ID: EDF0F620-B15B-4348-9532-9522D1114EDD@pervasive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mar 23, 2006, at 11:01 AM, Just Someone wrote:

> I was doing some load testing on a server, and decided to test it with
> different file systems to see how it reacts to load/speed. I tested
> xfs, jfs and ext3. The machine runs FC4 with the latest 2.6.15 kernel
> from Fedora.

You should also try testing ext3 with data=writeback, on both
partitions. People have found it makes a big difference in performance.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2006-03-23 18:00:13 Re: COPY command documentation
Previous Message Jim Nasby 2006-03-23 17:54:51 Re: Some pgbench results