On Mon, Oct 25, 2021 at 07:53:02PM +0200, Chris Travers wrote:
> On the whole ZFS on spinning disks is going to have some performance... rough
> corners..... And it is a lot harder to reason about a lot of things including
> capacity and performance when you are doing copy on write on both the db and FS
> level, and have compression in the picture. And there are other areas of
> complexity, such as how you handle partial page writes.
>
> On the whole I think for small dbs it might perform well enough. On large or
> high velocity dbs I think you will have more problems than expected.
>
> Having worked with PostgreSQL on ZFS I wouldn't generally recommend it as a
> general tool.
I know ZFS has a lot of features/options, and some of those can cause
corruption, so if you modify ZFS options, you need to be sure they don't
affect Postgres reliability.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.