Episode 127 Recursive Queries | Lateral Joins | Pagination | JSONB Arrays

<p>In this episode of Scaling Postgres, we discuss recursive queries, using lateral joins, paging through a data sets efficiently and working with JSONB arrays.</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://www.postgresql.org/about/news/2060/">https://www.postgresql.org/about/news/2060/</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/recursive-queries-postgresql/"> https://www.cybertec-postgresql.com/en/recursive-queries-postgresql/</a></p> <p><a href= "https://info.crunchydata.com/blog/iterators-in-postgresql-with-lateral-joins"> https://info.crunchydata.com/blog/iterators-in-postgresql-with-lateral-joins</a></p> <p><a href= "https://momjian.us/main/blogs/pgblog/2020.html#August_12_2020">https://momjian.us/main/blogs/pgblog/2020.html#August_12_2020</a></p> <p><a href= "https://engineering.shopify.com/blogs/engineering/pagination-relative-cursors"> https://engineering.shopify.com/blogs/engineering/pagination-relative-cursors</a></p> <p><a href= "https://use-the-index-luke.com/sql/partial-results/fetch-next-page"> https://use-the-index-luke.com/sql/partial-results/fetch-next-page</a></p> <p><a href= "https://levelup.gitconnected.com/working-with-a-jsonb-array-of-objects-in-postgresql-d2b7e7f4db87"> https://levelup.gitconnected.com/working-with-a-jsonb-array-of-objects-in-postgresql-d2b7e7f4db87</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/running-multiple-pgbouncer-instances-with-systemd/"> https://www.2ndquadrant.com/en/blog/running-multiple-pgbouncer-instances-with-systemd/</a></p> <p><a href= "https://www.highgo.ca/2020/08/08/partitioning-improvements-in-postgresql-13/"> https://www.highgo.ca/2020/08/08/partitioning-improvements-in-postgresql-13/</a></p> <p><a href= "https://www.highgo.ca/2020/08/10/postgresql-high-availability-the-considerations-and-candidates/"> https://www.highgo.ca/2020/08/10/postgresql-high-availability-the-considerations-and-candidates/</a></p> <p><a href= "https://www.hi