In this episode of Scaling Postgres, we discuss easily writing a recursive CTE, the zheap undo capability, high availability considerations and fast ways to load data.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

https://dev.to/yugabyte/learn-how-to-write-sql-recursive-cte-in-5-steps-3n88 https://www.cybertec-postgresql.com/en/zheap-undo-logs-discarding-in-postgresql/ https://tapoueh.org/blog/2021/12/postgres-ha-roles-are-dynamic/ https://pganalyze.com/blog/fastest-way-importing-data-into-postgres-with-ruby-rails https://aiven.io/blog/explore-the-new-search-and-cycle-features-in-postgresql-14 http://blog.cleverelephant.ca/2021/12/knn-syntax.html https://www.citusdata.com/blog/2021/12/11/uk-covid-19-dashboard-built-using-postgres-and-citus/ https://www.cybertec-postgresql.com/en/manage-encryption-keys-with-postgresql-tde/ https://www.percona.com/blog/postgresql-high-availability-and-disaster-recovery-on-kubernetes https://postgresql.life/post/ashutosh_bapat/ https://www.rubberduckdevshow.com/episodes/22-code-quality-analyzers/