From: Greg Smith <greg@2ndquadrant.com>
To: Jon Nelson <jnelson+pgsql@jamponi.net>
Cc: Scott Carey <scott@richrelevance.com>
Cc: Marti Raudsepp <marti@juffo.org>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
Date: Wed, 17 Nov 2010 17:48:31 -0500
Message-ID: <4CE45BBF.7000507@2ndquadrant.com> (raw)
In-Reply-To: <AANLkTimtO6FhmGwpyUZSemCCS98-NpmEOfK=NdwapHpv@mail.gmail.com>
References: <AANLkTi=n3zxiLNFhbpiN=JPQPwB=BhXf9iepw1KOEs8U@mail.gmail.com>
<4CCDCAA3.4050805@2ndquadrant.com>
<201011010010.28724.andres@anarazel.de>
<4CD472CC.80006@2ndquadrant.com>
<AANLkTinEAmKDz7x356bgX=-6x7zpjK3bB0hYAmKvYHB9@mail.gmail.com>
<4CE2EBF8.4040602@2ndquadrant.com>
<499BFB3F-CD9F-47D2-87E4-058C2A6D63EC@richrelevance.com>
<4CE44826.2070508@2ndquadrant.com>
<AANLkTimtO6FhmGwpyUZSemCCS98-NpmEOfK=NdwapHpv@mail.gmail.com>
Jon Nelson wrote:
> One thing to note is that where on a disk things sit can make a /huge/
> difference - depending on if Ubuntu is /here/ and RHEL is /there/ and
> so on can make a factor of 2 or more difference. The outside tracks
> of most modern SATA disks can do around 120MB/s. The inside tracks
> aren't even half of that.
>
You're talking about changes in sequential read and write speed due to
Zone Bit Recording (ZBR) AKA Zone Constant Angular Velocity (ZCAV).
What I was measuring was commit latency time on small writes. That
doesn't change as you move around the disk, since it's tied to the raw
rotation speed of the drive rather than density of storage in any zone.
If I get to something that's impacted by sequential transfers rather
than rotation time, I'll be sure to use the same section of disk for
that. It wasn't really necessary to get these initial gross numbers
anyway. What I was looking for is the about 10:1 speedup seen on this
hardware when the write cache is used, which could easily be seen even
were there ZBR differences involved.
--
Greg Smith 2ndQuadrant US greg@2ndQuadrant.com Baltimore, MD
PostgreSQL Training, Services and Support www.2ndQuadrant.us
"PostgreSQL 9.0 High Performance": http://www.2ndQuadrant.com/books
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: greg@2ndquadrant.com, jnelson+pgsql@jamponi.net, scott@richrelevance.com, marti@juffo.org
Subject: Re: Defaulting wal_sync_method to fdatasync on Linux for 9.1?
In-Reply-To: <4CE45BBF.7000507@2ndquadrant.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