Scaling Postgres

In this episode of Scaling Postgres, we discuss how to use recursive CTEs, database access patterns, using dates and times and how to cluster your data. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://towardsdatascience.com/recursive-sql-queries-with-postgresql-87e2a453f1b http://calpaterson.com/activerecord.html https://nanmu.me/en/posts/2020/postgresql-date-and-time-data-types-explained/ https://www.cybertec-postgresql.com/en/cluster-improving-postgresql-performance/ https://mydbanotebook.org/post/troubleshooting-01/ https://www.youtube.com/user/socallinuxexpo/videos https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-5-returning-results/ https://postgresql.life/post/bruce_momjian/ https://info.crunchydata.com/blog/crunchy-spatial-tile-serving-with-postgresql-functions https://www.highgo.ca/2020/03/18/postgresql-gssapi-authentication-with-kerberos-part-1-how-to-setup-kerberos-on-ubuntu/ https://www.cybertec-p