Re: BBU Cache vs. spindles

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Bruce Momjian <bruce(at)momjian(dot)us>, jd(at)commandprompt(dot)com, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, Steve Crawford <scrawford(at)pinpointresearch(dot)com>, pgsql-performance(at)postgresql(dot)org, Ben Chobot <bench(at)silentmedia(dot)com>
Subject: Re: BBU Cache vs. spindles
Date: 2010-10-22 16:36:22
Message-ID: 4CC1BD86.8070006@krogh.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance pgsql-www

On 2010-10-22 17:37, Greg Smith wrote:
> I think that most people who have thought they were safe to turn off
> full_page_writes in the past did so because they believed they were
> in category (1) here. I've never advised anyone to do that, because
> it's so difficult to validate the truth of. Just given that, I'd be
> tempted to join in on suggesting this parameter just go away in the
> name of safety, except that I think category (2) here is growing now.
> ZFS is the most obvious example where the atomic write implementation
> seems to always make disabling full_page_writes safe.

Can you point to some ZFS docs that tell that this is the case.. I'd be
surprised
if it doesnt copy away the old block and replaces it with the new one
in-place. The
other behaviour would quite quickly lead to a hugely fragmented
filesystem that
performs next to useless and ZFS doesnt seem to be in that category..

... All given my total lack of insight into ZFS.

--
Jesper

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Rob Wultsch 2010-10-22 17:16:57 Re: BBU Cache vs. spindles
Previous Message Greg Smith 2010-10-22 15:37:23 Re: BBU Cache vs. spindles

Browse pgsql-www by date

  From Date Subject
Next Message Rob Wultsch 2010-10-22 17:16:57 Re: BBU Cache vs. spindles
Previous Message Greg Smith 2010-10-22 15:37:23 Re: BBU Cache vs. spindles