Episode 196 Easy Recursive CTE | Zheap Undo | High Availability | Loading Data

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://dev.to/yugabyte/learn-how-to-write-sql-recursive-cte-in-5-steps-3n88"> https://dev.to/yugabyte/learn-how-to-write-sql-recursive-cte-in-5-steps-3n88</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/zheap-undo-logs-discarding-in-postgresql/"> https://www.cybertec-postgresql.com/en/zheap-undo-logs-discarding-in-postgresql/</a><br /> <br /> <a href= "https://tapoueh.org/blog/2021/12/postgres-ha-roles-are-dynamic/">https://tapoueh.org/blog/2021/12/postgres-ha-roles-are-dynamic/</a><br /> <br /> <a href= "https://pganalyze.com/blog/fastest-way-importing-data-into-postgres-with-ruby-rails"> https://pganalyze.com/blog/fastest-way-importing-data-into-postgres-with-ruby-rails</a><br /> <br /> <a href= "https://aiven.io/blog/explore-the-new-search-and-cycle-features-in-postgresql-14"> https://aiven.io/blog/explore-the-new-search-and-cycle-features-in-postgresql-14</a><br /> <br /> <a href= "http://blog.cleverelephant.ca/2021/12/knn-syntax.html">http://blog.cleverelephant.ca/2021/12/knn-syntax.html</a><br /> <br /> <a href= "https://www.citusdata.com/blog/2021/12/11/uk-covid-19-dashboard-built-using-postgres-and-citus/"> https://www.citusdata.com/blog/2021/12/11/uk-covid-19-dashboard-built-using-postgres-and-citus/</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/manage-encryption-keys-with-postgresql-tde/"> https://www.cybertec-postgresql.com/en/manage-encryption-keys-with-postgresql-tde/</a><br /> <br /> <a href= "https://www.percona.com/blog/postgresql-high-availability-and-disaster-recovery-on-kubernetes"> https://www.percona.com/blog/postgresql-high-availability-and-disaster-recovery-on-kubernetes</a><br /> <br /> <a href= "https://postgresql.life/post/ashutosh_bapat/">ht