Re: Filesystem benchmarking for pg 8.3.3 server

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Ron Mayer" <rm_pg(at)cheapcomplexdevices(dot)com>
Cc: "Greg Smith" <gsmith(at)gregsmith(dot)com>, Henrik <henke(at)mac(dot)se>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
Date: 2008-08-13 14:48:17
Message-ID: dcc563d10808130748m3a8fe7f8n2a64965990317697@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Aug 13, 2008 at 8:41 AM, Ron Mayer
<rm_pg(at)cheapcomplexdevices(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Decibel! 2008-08-13 14:50:51 Re: query plan, index scan cost
Previous Message Ron Mayer 2008-08-13 14:41:27 Re: Filesystem benchmarking for pg 8.3.3 server