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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Jignesh Shah <J(dot)K(dot)Shah(at)Sun(dot)COM>
Cc: 李彦 Ian Li <liyan82(at)gmail(dot)com>, PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: ZFS and Postgresql - WASRe: Best OS for Postgres 8.2
Date: 2007-05-09 17:01:45
Message-ID: 20070509170145.GS4504@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jim Nasby 2007-05-09 17:10:34 Re: Best OS for Postgres 8.2
Previous Message Jignesh Shah 2007-05-09 16:27:30 ZFS and Postgresql - WASRe: Best OS for Postgres 8.2