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

In this episode of Scaling Postgres, we discuss recursive queries, using lateral joins, paging through a data sets efficiently and working with JSONB arrays.

Content Discussed

PostgreSQL 12.4, 11.9, 10.14, 9.6.19, 9.5.23, and 13 Beta 3 Released!
Understanding recursive queries in PostgreSQL
Iterators in PostgreSQL with Lateral Joins
Keyset Pagination
Pagination with Relative Cursors
Paging Through Results
Working with a JSONB Array of Objects in PostgreSQL
Running multiple PgBouncer instances with systemd
Partitioning Improvements in PostgreSQL 13
PostgreSQL High Availability: The Considerations and Candidates
Consensus based failover with Pgpool-II
Building a recommendation engine inside Postgres with Python and Pandas
Michael Brewer