Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2 - Mailing list pgsql-performance

From Alvaro Herrera
Subject Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
Date
Msg-id 20070509170145.GS4504@alvh.no-ip.org
Whole thread Raw
In response to ZFS and Postgresql - WASRe: Best OS for Postgres 8.2  (Jignesh Shah <J.K.Shah@Sun.COM>)
Responses Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
List pgsql-performance
Jignesh Shah escribió:

> Now comes the thing that I am still exploring
> * Do we do checksum in WAL ? I guess we do .. Which means that we are
> now doing double checksumming on the data. One in ZFS and one in
> postgresql. ZFS does allow checksumming to be turned off (but on new
> blocks allocated). But of course the philosophy is where should it be
> done (ZFS or PostgreSQL).

Checksums on WAL are not optional in Postgres, because AFAIR they are
used to determine when it should stop recovering.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-performance by date:

Previous
From: Jignesh Shah
Date:
Subject: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
Next
From: Jim Nasby
Date:
Subject: Re: Best OS for Postgres 8.2