pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL optimizations for CoW FS
2+ messages / 2 participants
[nested] [flat]
* PostgreSQL optimizations for CoW FS
@ 2023-02-22 09:41 HECTOR INGERTO <HECTOR_25E@hotmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: HECTOR INGERTO @ 2023-02-22 09:41 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: PostgreSQL optimizations for CoW FS
@ 2023-02-24 16:13 Peter Eisentraut <peter.eisentraut@enterprisedb.com>
parent: HECTOR INGERTO <HECTOR_25E@hotmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Peter Eisentraut @ 2023-02-24 16:13 UTC (permalink / raw)
To: HECTOR INGERTO <HECTOR_25E@hotmail.com>; pgsql-general
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2023-02-24 16:13 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-02-22 09:41 PostgreSQL optimizations for CoW FS HECTOR INGERTO <HECTOR_25E@hotmail.com>
2023-02-24 16:13 ` Peter Eisentraut <peter.eisentraut@enterprisedb.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox