From: Scott Marlowe <scott.marlowe@gmail.com>
To: Ron Mayer <rm_pg@cheapcomplexdevices.com>
Cc: Greg Smith <gsmith@gregsmith.com>
Cc: Henrik <henke@mac.se>
Cc: pgsql-performance@postgresql.org
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
Date: Wed, 13 Aug 2008 08:48:17 -0600
Message-ID: <dcc563d10808130748m3a8fe7f8n2a64965990317697@mail.gmail.com> (raw)
In-Reply-To: <48A2F297.9030703@cheapcomplexdevices.com>
References: <32A7A76B-16CA-4CDB-AD43-973AD6A3FC7B@mac.se>
<Pine.GSO.4.64.0808081835320.21924@westnet.com>
<48A2050D.4050803@cheapcomplexdevices.com>
<Pine.GSO.4.64.0808130150510.9761@westnet.com>
<48A2F297.9030703@cheapcomplexdevices.com>
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.
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: scott.marlowe@gmail.com, rm_pg@cheapcomplexdevices.com, gsmith@gregsmith.com, henke@mac.se
Subject: Re: Filesystem benchmarking for pg 8.3.3 server
In-Reply-To: <dcc563d10808130748m3a8fe7f8n2a64965990317697@mail.gmail.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