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
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 |
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 |