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

• Michael Brewer
• 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

YouTube Video