Recursive CTEs, DB Access Patterns, Dates & Times, Cluster | Scaling Postgres 106
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/
Create your
podcast in
minutes
It is Free