| From: | Rui DeSousa <rui(at)crazybean(dot)net> |
|---|---|
| To: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
| Cc: | pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: WAL & ZFS |
| Date: | 2022-03-31 21:32:58 |
| Message-ID: | 43EEBE2E-4C7F-4F35-99BF-4DA8B5D3828A@crazybean.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I would recommend a separate pg_wal filesystem with the record size to match the WAL page size; in my case 16k. I have keep the default record size at 128k for the data volume and that configuration has worked well for supporting large DSS while using 16k data blocks.
> On Mar 30, 2022, at 5:32 PM, Scott Ribe <scott_ribe(at)elevated-dev(dot)com> wrote:
>
> I've read all the info I could find re running PG on ZFS: turn off full page writes, turn on lz4, tweak recordsize so as to take advantage of compression, etc. One thing I haven't seen is whether a separate volume for WAL would benefit from a larger recordsize. Or any other tweaks???
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> https://www.linkedin.com/in/scottribe/
>
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Jakobs | 2022-03-31 22:47:36 | Re: WAL & ZFS |
| Previous Message | Scott Ribe | 2022-03-30 21:32:36 | WAL & ZFS |