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-postgis

https://blog.rustprooflabs.com/2021/05/osm2pgsql-reduced-ram-load-to-postgis

https://www.cybertec-postgresql.com/en/publishing-maps-with-geoserver-and-postgis/
https://postgresql.life/post/dave_page/