Scaling Postgres

In this episode of Scaling Postgres, we review articles covering the future of sharding PostgreSQL databases, query optimization, replication read performance and PostGIS. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: http://rhaas.blogspot.com/2018/05/built-in-sharding-for-postgresql.html https://statsbot.co/blog/postgresql-query-optimization/ https://medium.com/@yuliaoletskaya/how-postgresql-analysis-helped-to-gain-290-times-performance-boost-for-a-particular-request-938dc69580da https://blog.timescale.com/scalable-postgresql-high-availability-read-scalability-streaming-replication-fb95023e2af https://www.youtube.com/watch?v=eQKbbCg0NqE http://s3.cleverelephant.ca/2018-postgis-for-managers.pdf https://www.citusdata.com/blog/2018/05/15/fun-with-sql-recursive-ctes/