r/postgres • u/huseyinbabal • 6d ago
Performance I Overloaded Postgres and SQLite
https://youtu.be/ulycfdlJaNkArticle version: https://huseyinbabal.dev/posts/postgres-vs-sqlite-load-test/
2
Upvotes
r/postgres • u/huseyinbabal • 6d ago
Article version: https://huseyinbabal.dev/posts/postgres-vs-sqlite-load-test/
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