Episode 164 Fast Random Rows | Fast Distinct Queries | Temp & Unlogged Tables | Terminating Connections

<p>In this episode of Scaling Postgres, we discuss selecting random rows quickly, faster distinct queries, how replication handles temp and unlogged tables and how to terminate connections.</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://blog.hagander.net/getting-random-rows-faster-very-much-faster-249/"> https://blog.hagander.net/getting-random-rows-faster-very-much-faster-249/</a><br /> <br /> <a href= "https://blog.timescale.com/blog/how-we-made-distinct-queries-up-to-8000x-faster-on-postgresql/"> https://blog.timescale.com/blog/how-we-made-distinct-queries-up-to-8000x-faster-on-postgresql/</a><br /> <br /> <a href= "https://fluca1978.github.io/2021/05/10/PostgreSQLUnloggedTablesReplication.html"> https://fluca1978.github.io/2021/05/10/PostgreSQLUnloggedTablesReplication.html</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/terminating-database-connections-in-postgresql/"> https://www.cybertec-postgresql.com/en/terminating-database-connections-in-postgresql/</a><br /> <br /> <a href= "https://www.tangramvision.com/blog/creating-postgresql-test-data-with-sql-pl-pgsql-and-python"> https://www.tangramvision.com/blog/creating-postgresql-test-data-with-sql-pl-pgsql-and-python</a><br /> <br /> <a href= "https://momjian.us/main/blogs/pgblog/2021.html#May_3_2021">https://momjian.us/main/blogs/pgblog/2021.html#May_3_2021</a><br /> <br /> <a href= "https://akorotkov.github.io/blog/2021/05/06/jsonpath-double-asterisk-lax/"> https://akorotkov.github.io/blog/2021/05/06/jsonpath-double-asterisk-lax/</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/using-kubernetes-chances-are-you-need-a-database"> https://blog.crunchydata.com/blog/using-kubernetes-chances-are-you-need-a-database</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/the-many-spatial-indexes-of-postgis"> https://blog.crunchydata.com/blog/the-many-spatial-indexes-of-postgis</a><br /> <br /> <a href= "https://blog.rustproofla