fillfactor and cluster table vs ZFS copy-on-write

From: Geoff Speicher <gspeicher(at)umtechx(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: fillfactor and cluster table vs ZFS copy-on-write
Date: 2015-04-16 12:09:01
Message-ID: CACEYah1en0ATkZNm75WRYt2D-MpK-cxPkROnXOWV9L=gmVQZfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to determine the behavior of a system using ZFS to back a
PostgreSQL instance as it relates to fillfactor and table clustering.

ZFS implements copy-on-write, so when PostgreSQL modifies a block on disk,
the filesystem writes a new block rather than updating the existing block.
Unless I'm missing something, this would seem to negate the purpose of
using any fillfactor less than 100% and reduce any benefits of using
CLUSTER. In fact, when using ZFS snapshots, it would seem that CLUSTER
would actually be wasteful.

Therefore one might posit that PostgreSQL should be configured to use 100%
fillfactor and avoid clustering on ZFS. Can anyone comment on this?

Thanks,
Geoff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message William Dunn 2015-04-16 14:52:52 PL\pgSQL 'ERROR: invalid input syntax for type oid:' [PostgreSQL 9.3.6 and 9.4]
Previous Message PT 2015-04-15 21:56:43 Re: Error in the connection to the server