
Scaling Postgres Episode 127 Recursive Queries | Lateral Joins | Pagination | JSONB Arrays
Get New Episodes Weekly!
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