Recursive Queries, Lateral Joins, Pagination, JSONB Arrays | Scaling Postgres 127
In this episode of Scaling Postgres, we discuss recursive queries, using lateral joins, paging through a data sets efficiently and working with JSONB arrays.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://www.postgresql.org/about/news/2060/
https://www.cybertec-postgresql.com/en/recursive-queries-postgresql/
https://info.crunchydata.com/blog/iterators-in-postgresql-with-lateral-joins
https://momjian.us/main/blogs/pgblog/2020.html#August_12_2020
https://engineering.shopify.com/blogs/engineering/pagination-relative-cursors
https://use-the-index-luke.com/sql/partial-results/fetch-next-page
https://levelup.gitconnected.com/working-with-a-jsonb-array-of-objects-in-postgresql-d2b7e7f4db87
https://www.2ndquadrant.com/en/blog/running-multiple-pgbouncer-instances-with-systemd/
https://www.highgo.ca/2020/08/08/partitioning-improvements-in-postgresql-13/
https://www.highgo.ca/2020/08/10/postgresql-high-availability-the-considerations-and-candidates/
https://www.highgo.ca/2020/08/11/consensus-based-failover-with-pgpool-ii/
https://info.crunchydata.com/blog/recommendation_engine_in_postgres_with_pandas_and_python
https://postgresql.life/post/michael_brewer/
Create your
podcast in
minutes
It is Free