| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | postgres performance list <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: 8K recordsize bad on ZFS? |
| Date: | 2010-05-10 18:39:10 |
| Message-ID: | 4BE852CE.9020802@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Voras | 2010-05-10 19:13:54 | Re: 8K recordsize bad on ZFS? |
| Previous Message | Scott Marlowe | 2010-05-10 02:39:24 | Re: Dell Perc HX00 RAID controllers: What's inside? |