Scaling Postgres

In this episode of Scaling Postgres, we discuss different query optimizations, normalizing to save space, visualizing vacuum and shardings future. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1943/ https://parallelthoughts.xyz/2019/05/a-tale-of-query-optimization/ https://blog.checklyhq.com/how-i-decimated-postgres-response-times-for-my-saas/ https://www.youtube.com/watch?v=vfiz1J8mWEs https://fluca1978.github.io/2019/05/31/RefactorToSaveSpace.html http://dtrace.org/blogs/dap/2019/05/22/visualizing-postgresql-vacuum-progress/ https://www.citusdata.com/blog/2019/05/30/introducing-pg-auto-failover/ https://www.2ndquadrant.com/en/blog/swoop-de-dupe/ http://momjian.us/main/writings/pgsql/sharding.pdf http://blog.cleverelephant.ca/2019/05/parallel-postgis-4.html https://info.crunchydata.com/blog/active-active-on-kubernetes