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-postgresql.com/en/pg_timetable-advanced-postgresql-cron-like-scheduler-released/