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/