Search

Home > Scaling Postgres > Episode 164 Fast Random Rows | Fast Distinct Queries | Temp & Unlogged Tables | Terminating Connections
Podcast: Scaling Postgres
Episode:

Episode 164 Fast Random Rows | Fast Distinct Queries | Temp & Unlogged Tables | Terminating Connections
Category: Technology
Duration: 00:17:30
Publish Date: 2021-05-09 20:19:12
Description:

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/
Total Play: 0