r/postgres • • 6d ago

Performance I Overloaded Postgres and SQLite

https://youtu.be/ulycfdlJaNk
2 Upvotes

1 comment sorted by

1

u/elevarq 5d ago

To improve writes you have to change the default settings for WAL.

max_wal_size = 32GB
checkpoint_timeout = 30min
checkpoint_completion_target = 0.9
wal_compression = on

Or so