Scaling Postgres

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. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://blog.hagander.net/getting-random-rows-faster-very-much-faster-249/ https://blog.timescale.com/blog/how-we-made-distinct-queries-up-to-8000x-faster-on-postgresql/ https://fluca1978.github.io/2021/05/10/PostgreSQLUnloggedTablesReplication.html https://www.cybertec-postgresql.com/en/terminating-database-connections-in-postgresql/ https://www.tangramvision.com/blog/creating-postgresql-test-data-with-sql-pl-pgsql-and-python https://momjian.us/main/blogs/pgblog/2021.html#May_3_2021 https://akorotkov.github.io/blog/2021/05/06/jsonpath-double-asterisk-lax/ https://blog.crunchydata.com/blog/using-kubernetes-chances-are-you-need-a-database https://blog.crunchydata.com/blog/the-many-spatial-indexes-of-pos