In this episode of Scaling Postgres, we discuss little known useful features, a monthly community blogging initiative, PG 15 Anticipation, and getting generic plans.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://it.badykov.com/blog/2022/09/12/simple-and-usefull-postgresql-features/
- https://www.softwareandbooz.com/introducing-psql-phriday/
- https://www.youtube.com/watch?v=b-C3TjmzEmU
- https://dev.to/yugabyte/explain-from-pgstatstatements-normalized-queries-how-to-always-get-the-generic-plan-in--5cfi
- https://pganalyze.com/blog/5mins-postgres-explain-pg-stat-statements-plan-cache-mode-normalized-query
- https://www.cybertec-postgresql.com/en/what-is-an-inner-join-in-sql-and-what-is-an-outer-join/
- https://proopensource.it/blog/json-versus-jsonb
- https://www.percona.com/blog/working-with-snapshots-in-postgresql/
- https://www.crunchydata.com/blog/postgres-pgcrypto
- https://www.citusdata.com/blog/2022/09/12/distributed-postgres-goes-full-open-source-with-citus/
- https://b-peng.blogspot.com/2022/09/configuring-vip-in-cloud.html
- https://postgres.fm/episodes/macro-query-analysis-intro
- https://postgresql.life/post/karen_jex/
- https://www.rubberduckdevshow.com/episodes/58-engineering-vs-product-managers-with-brittany-martin-josh-gaastra/