Scaling Postgres

Useful Features, Community Blogging, PG 15 Anticipation, Generic Plans | Scaling Postgres 233

Informações:

Synopsis

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-wit