Query Optimization, Normalization, Visualizing Vacuum, Sharding | Scaling Postgres 66
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
Create your
podcast in
minutes
It is Free