Scaling Postgres

In this episode of Scaling Postgres, we discuss ways to work around the planner, working with grouping sets, using a lateral join and not-so-easy Postgres issues. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://heap.io/blog/when-the-postgres-planner-is-not-very-smart https://www.cybertec-postgresql.com/en/postgresql-grouping-sets-rollup-cube/ https://fluca1978.github.io/2021/08/07/PostgreSQLLateralJoin.html https://pgdash.io/blog/postgresql-six-not-so-easy-pieces.html https://www.postgresql.fastware.com/blog/logical-decoding-of-two-phase-commits https://blog.crunchydata.com/blog/using-cert-manager-to-deploy-tls-for-postgres-on-kubernetes https://postgresql.life/post/bryn_llewellyn/ https://www.rubberduckdevshow.com/episodes/7-writing-secure_code/