Re: Enabling Checksums - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Enabling Checksums
Date
Msg-id 5137CA90.4020906@agliodbs.com
Whole thread Raw
In response to Re: Enabling Checksums  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Enabling Checksums  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert,

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

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: Materialized views WIP patch
Next
From: Robert Haas
Date:
Subject: Re: Enabling Checksums