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.
In questa pagina del sito puoi guardare il video online synchronous_commit | Postgres.FM 143 | della durata di ore minuti seconda in buona qualità , che l'utente ha caricato PostgresTV 01 gennaio 1970, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 423 volte e gli è piaciuto 19 spettatori. Buona visione!
