pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PostgreSQL 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>
  2023-02-24 16:13 ` Re: PostgreSQL optimizations for CoW FS Peter Eisentraut <peter.eisentraut@enterprisedb.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-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>
  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