Scaling Postgres

In this episode of Scaling Postgres, we review articles covering bloat vs. zheap, composite indexes, unsafe operations, and being a better developer. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://labs.contactually.com/dealing-with-significant-postgres-database-bloat-what-are-your-options-a6c1814a03a5 https://www.youtube.com/watch?v=cvCLFZbtJxQ https://www.pgcon.org/2018/schedule/attachments/501_zheap-a-new-storage-format-postgresql-5.pdf https://blog.timescale.com/use-composite-indexes-to-speed-up-time-series-queries-sql-8ca2df6b3aaa https://leopard.in.ua/2016/09/20/safe-and-unsafe-operations-postgresql https://www.youtube.com/watch?v=IwahVdNboc8 https://www.youtube.com/watch?v=0cZ4elFNAQQ https://www.youtube.com/watch?v=hWh8QoV8z8k https://www.youtube.com/watch?v=gV5W4AhWBzo https://tapoueh.org/blog/2018/11/preventing-sql-injections/ http://evol-monkey.blogspot.com/2018/11/zero-downtime-upgrade-postgresql-10-to.html https://severalnines.co