Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2

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