zalando / spilo

Highly available elephant herd: HA PostgreSQL cluster using Docker
Apache License 2.0
1.51k stars 371 forks source link

Use separate disks for WAL and data #984

Open anasanjaria opened 4 months ago

anasanjaria commented 4 months ago

One of the performance optimization technique for insertion according to Timescaledb blog is to use separate disks for WAL & data.

According to blog [1],

Use separate disks for WAL and data
-----------------------------------
While this is a more advanced optimization that isn't always needed, if your disk becomes a bottleneck,
you can further increase throughput by using a separate disk (tablespace) for the database's write-ahead log (WAL) and data.

[1] https://www.timescale.com/blog/13-tips-to-improve-postgresql-insert-performance/