PostgreSQL optimizations for CoW FS

From: HECTOR INGERTO <HECTOR_25E(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL optimizations for CoW FS
Date: 2023-02-22 09:41:37
Message-ID: GV1P189MB20365AD739371E758DDB05CEF5AA9@GV1P189MB2036.EURP189.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Let’s say we have to run a PostgreSQL instance on top of a copy on write filesystem like ZFS or BTRFS. In adittion to set full_page_writes = off, what other optimizations can be done on the PostgreSQL side?

Regards,

Héctor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2023-02-22 09:51:33 Re: Event Triggers unable to capture the DDL script executed
Previous Message Neethu P 2023-02-22 07:57:21 Event Triggers unable to capture the DDL script executed