ABOUT THIS EPISODE
Nik and Michael discuss hot_standby_feedback — what it controls, whether and when read replicas should be changed to on, and other settings you can change to help too.
Here are some links to things they mentioned:
- hot_standby_feedback https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-HOT-STANDBY-FEEDBACK
- hot_standby_feedback: experiments on PostgreSQL 17 (by Nik) https://console.postgres.ai/shared/brief/6018f69d-8975-48e3-8259-a72c77105572
- Best practices for Amazon RDS PostgreSQL replication (blog post) https://aws.amazon.com/blogs/database/best-practices-for-amazon-rds-postgresql-replication/
- log_autovacuum_min_duration https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-AUTOVACUUM-MIN-DURATION
- max_standby_streaming_delay https://www.postgresql.org/docs/current/runtime-config-replication.html#GUC-MAX-STANDBY-STREAMING-DELAY
- WAIT FOR LSN https://www.postgresql.org/docs/19/sql-wait-for.html
- transaction_timeout https://www.postgresql.org/docs/current/runtime-config-client.html#GUC-TRANSACTION-TIMEOUT
- Hot Standby Feedback should default to on in 9.3+ https://www.postgresql.org/message-id/flat/20121130190227.GJ3957%40awork2.anarazel.de
~~~
What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc!
~~~
Postgres FM is produced by:
- Michael Christofides, founder of pgMustard
- Nikolay Samokhvalov, founder of Postgres.ai
With credit to:
- Jessie Draws for the elephant artwork
English
United States
TRANSCRIPT 🔗
Are you the producer of this podcast?
Add a podcast transcript
Need Audio-to-Text?
Transcribe with Listen411 in Just 60 Seconds
OTHER EPISODES IN THIS PODCAST
Nik and Michael are joined by Tudor Golubenco, CTO of Xata, to discuss their architecture, progress, and open source tooling. Here are some links to things they mentioned:
Tudor Golubenco https://postgres.fm/people/tudor-golubenco
Xata https://xata.io
Xata is now open source https://xata.io/blog/…
Nik and Michael are joined by David Steele to talk all things pgBackRest. Here are some links to things they mentioned:
David Steele https://postgres.fm/people/david-steele
pgBackRest https://pgbackrest.org
pg_basebackup https://www.postgresql.org/docs/current/app-pgbasebackup.html
Barman https:/…
Nik and Michael are joined by Fabrízio Mello to discuss his new extension pg_stat_log.
Here are some links to things they mentioned:
Fabrízio Mello https://postgres.fm/people/fabrizio-de-royes-mello
Timbira https://www.timbira.com.br
PlanetScale https://planetscale.com
pg_stat_log https://github.…
Nik and Michael discuss autovacuum, including what it does, and the basics of why and how to tune it. Here are some links to things they mentioned:
autovacuum https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM
autovacuum configuration parameters https://www.postgresql.org/…
Nik and Michael are joined by Qian Li and Peter Kraft to talk about DBOS, an open source platform for durable workflows built on Postgres. Here are some links to things they mentioned:
Qian Li https://postgres.fm/people/qian-li
Peter Kraft https://postgres.fm/people/peter-kraft
DBOS https://www.…
Disclaimer: The podcast and artwork embedded on this page are from Nikolay Samokhvalov and Michael Christofides, which is the property of its owner and not affiliated with or endorsed by Listen Notes, Inc.
EDIT
Thank you for helping to keep the podcast database up to date.
