درباره این اپیزود
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
انگلیسی
ایالات متحده آمریکا
رونوشت 🔗
Are you the producer of this podcast?
Add a podcast transcript
Need Audio-to-Text?
Transcribe with Listen411 in Just 60 Seconds
جستجوی اپیزودهای گذشته
اپیزودهای قبلی Postgres FM را جستجو کن.
قسمت های دیگر در این پادکست
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 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.…
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 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 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/…
سلب مسئولیت: پادکست و آثار هنری تعبیه شده در این صفحه متعلق به Nikolay Samokhvalov and Michael Christofides است که متعلق به صاحب آن است و به Listen Notes، Inc وابسته یا تایید نشده است.
ویرایش
از کمک شما برای بروز نگهداشتن پایگاهدادههای پادکست سپاسگزاریم
