Search


	Podcast:		Scaling Postgres
	Episode:		Episode 127 Recursive Queries \| Lateral Joins \| Pagination \| JSONB Arrays
	Category:		Technology
	Duration:		00:14:38
	Publish Date:		2020-08-17 00:21:53
	Description:		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/
	Total Play:		0