Re: Filesystem benchmarking for pg 8.3.3 server - Mailing list pgsql-performance

From Scott Marlowe
Subject Re: Filesystem benchmarking for pg 8.3.3 server
Date
Msg-id dcc563d10808130748m3a8fe7f8n2a64965990317697@mail.gmail.com
Whole thread Raw
In response to Re: Filesystem benchmarking for pg 8.3.3 server  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Responses Re: Filesystem benchmarking for pg 8.3.3 server  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-performance
On Wed, Aug 13, 2008 at 8:41 AM, Ron Mayer
<rm_pg@cheapcomplexdevices.com> wrote:
> Greg Smith wrote:

> But I still am looking for any evidence that there were any
> widely shipped SATA (or even IDE drives) that were at fault,
> as opposed to filesystem bugs and poor settings of defaults.

Well, if they're getting more than 150/166.6/250 transactions per
second without a battery backed cache, then they're likely lying about
fsync.  And most SATA and IDE drives will give you way over that for a
small data set.

pgsql-performance by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
Next
From: Decibel!
Date:
Subject: Re: query plan, index scan cost