synchronous_commit | Postgres.FM 143 |
[ 🇬🇧_🇺🇸 Check out the subtitles – we now edit them, ChatGPT+manually! You can also try YouTube's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss synchronous_commit — what it means on single node setups, for synchronous replication setups, and the pros and cons of the different options for each.
Here are some links to things they mentioned:
synchronous_commit https://www.postgresql.org/docs/curre...
synchronous_commit history on pgPedia https://pgpedia.info/s/synchronous_co...
Patroni’s maximum_lag_on_failover setting https://patroni.readthedocs.io/en/mas...
wal_writer_delay https://www.postgresql.org/docs/curre...
Selective asynchronous commits in PostgreSQL - balancing durability and performance (blog post by Shayon Mukherjee) https://www.shayon.dev/post/2025/75/s...
Asynchronous Commit https://www.postgresql.org/docs/curre...
synchronous_standby_names https://www.postgresql.org/docs/curre...
Jepson article about Amazon RDS multi-AZ clusters (by Kyle Kingsbury, aka "Aphyr”) https://jepsen.io/analyses/amazon-rds...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm / postgresfm , @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is produced by:
Nikolay Samokhvalov, founder of Postgres.ai https://postgres.ai/
Michael Christofides, founder of pgMustard https://pgmustard.com/
~~~
This is the video version. Check out https://postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.
Auf dieser Seite können Sie das Online-Video synchronous_commit | Postgres.FM 143 | mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer PostgresTV 01 Januar 1970 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 423 Mal angesehen und es wurde von 19 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
