Planner Workarounds, Grouping Sets, Lateral Join, Not-So-Easy | Scaling Postgres 177
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/
Create your
podcast in
minutes
It is Free