Re: Enabling Checksums - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: Enabling Checksums
Date
Msg-id 5137CDF7.9060707@commandprompt.com
Whole thread Raw
In response to Re: Enabling Checksums  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On 03/06/2013 03:06 PM, Robert Haas wrote:
>
> On Wed, Mar 6, 2013 at 6:00 PM, Josh Berkus <josh@agliodbs.com> wrote:
>>> We've had a few EnterpriseDB customers who have had fantastically
>>> painful experiences with PostgreSQL + ZFS.  Supposedly, aligning the
>>> ZFS block size to the PostgreSQL block size is supposed to make these
>>> problems go away, but in my experience it does not have that effect.
>>> So I think telling people who want checksums "go use ZFS" is a lot
>>> like telling them "oh, I see you have a hangnail, we recommend that
>>> you solve that by cutting your arm off with a rusty saw".
>>
>> Wow, what platform are you using ZFS on?
>>
>> (we have a half-dozen clients on ZFS ...)
>
> Not us, customers.  But as to platform, I have yet to run across
> anyone running ZFS on anything but Solaris.  I'd be interested to hear
> your experiences.   Mine rhyme with "sun a play dreaming".

I would guess he meant on X86_64 or Sparc.

JD


>


-- 
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Support, Training, Professional Services and Development
High Availability, Oracle Conversion, Postgres-XC
@cmdpromptinc - 509-416-6579



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Enabling Checksums
Next
From: Kevin Grittner
Date:
Subject: Re: odd behavior in materialized view