Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL optimizations for CoW FS - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: PostgreSQL optimizations for CoW FS
Date
Msg-id eeb74e31-e779-a4b5-ce4e-05706a90e686@enterprisedb.com
Whole thread Raw
In response to PostgreSQL optimizations for CoW FS  (HECTOR INGERTO <HECTOR_25E@hotmail.com>)
List pgsql-general
Tree view 
On 22.02.23 10:41, HECTOR INGERTO wrote:
> 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?

Look at the settings wal_init_zero and wal_recycle.

pgsql-general by date:

Previous
From: Tomas Pospisek
Date:
Subject: Re: can't get psql authentication against Active Directory working
Next
From: Adrian Klaver
Date:
Subject: Re: Debugging postgres on Windows - could not open directory "/lib"