From: Josh Berkus <josh@agliodbs.com>
To: postgres performance list <pgsql-performance@postgresql.org>
Subject: Re: 8K recordsize bad on ZFS?
Date: Mon, 10 May 2010 11:39:10 -0700
Message-ID: <4BE852CE.9020802@agliodbs.com> (raw)
In-Reply-To: <AANLkTim6rVYoAZaspbEnsyE9LPmWGXWe4Van40Snldoj@mail.gmail.com>
References: <4BE4ABC9.6040106@agliodbs.com>
<AANLkTim6rVYoAZaspbEnsyE9LPmWGXWe4Van40Snldoj@mail.gmail.com>
On 5/9/10 1:45 AM, Dimitri wrote:
> Josh,
>
> it'll be great if you explain how did you change the records size to
> 128K? - as this size is assigned on the file creation and cannot be
> changed later - I suppose that you made a backup of your data and then
> process a full restore.. is it so?
You can change the recordsize of the zpool dynamically, then simply copy
the data directory (with PostgreSQL shut down) to a new directory on
that zpool. This assumes that you have enough space on the zpool, of
course.
We didn't test how it would work to let the files in the Postgres
instance get gradually replaced by "natural" updating.
--
-- Josh Berkus
PostgreSQL Experts Inc.
http://www.pgexperts.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: josh@agliodbs.com
Subject: Re: 8K recordsize bad on ZFS?
In-Reply-To: <4BE852CE.9020802@agliodbs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox