Episode 106 Recursive CTEs | DB Access Patterns | Dates & Times | Cluster

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://towardsdatascience.com/recursive-sql-queries-with-postgresql-87e2a453f1b"> https://towardsdatascience.com/recursive-sql-queries-with-postgresql-87e2a453f1b</a></p> <p><a href= "http://calpaterson.com/activerecord.html">http://calpaterson.com/activerecord.html</a></p> <p><a href= "https://nanmu.me/en/posts/2020/postgresql-date-and-time-data-types-explained/"> https://nanmu.me/en/posts/2020/postgresql-date-and-time-data-types-explained/</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/cluster-improving-postgresql-performance/"> https://www.cybertec-postgresql.com/en/cluster-improving-postgresql-performance/</a></p> <p><a href= "https://mydbanotebook.org/post/troubleshooting-01/">https://mydbanotebook.org/post/troubleshooting-01/</a></p> <p><a href= "https://www.youtube.com/user/socallinuxexpo/videos">https://www.youtube.com/user/socallinuxexpo/videos</a></p> <p><a href= "https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-5-returning-results/"> https://www.2ndquadrant.com/en/blog/creating-a-postgresql-procedural-language-part-5-returning-results/</a></p> <p><a href= "https://postgresql.life/post/bruce_momjian/">https://postgresql.life/post/bruce_momjian/</a></p> <p><a href= "https://info.crunchydata.com/blog/crunchy-spatial-tile-serving-with-postgresql-functions"> https://info.crunchydata.com/blog/crunchy-spatial-tile-serving-with-postgresql-functions</a></p> <p><a href= "https://www.highgo.ca/2020/03/18/postgresql-gssapi-authentication-with-kerberos-part-1-how-to-setup-kerberos-on-ubuntu/"> https://www.highgo.ca/2020/03/18/postgresql-gssapi-authentication-with-kerberos-part-1-how-to-setup-kerberos-on-ubuntu/</a></p> <p><a href= "https://www.cybertec-postgresql.com/en/pg_timetable-a