In this episode of Scaling Postgres, we discuss merging indexes vs. a composite index, implementing transparent column encryption, developing trusted language extensions, and reviewing the WAL archive module.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

  • https://sirupsen.com/index-merges
  • https://supabase.com/blog/transparent-column-encryption-with-postgres
  • https://aws.amazon.com/blogs/aws/new-trusted-language-extensions-for-postgresql-on-amazon-aurora-and-amazon-rds/
  • https://pganalyze.com/blog/5mins-postgres-pg-tle-custom-extensions-aws-rds-aurora-trusted-languages-hooks
  • https://github.com/aws/pg_tle
  • https://www.percona.com/blog/new-wal-archive-module-library-in-postgresql-15/
  • https://sqlasylum.wordpress.com/2022/11/29/pgsql-phriday-003-what-is-the-community-to-you/
  • https://www.softwareandbooz.com/postgresql-community-passionate-knowledgeable-and-thoughtful/
  • https://www.scarydba.com/2022/12/02/pgsql-phriday-3-what-is-the-postgresql-community-to-you/
  • https://blog.rustprooflabs.com/2022/12/pgsql-phriday-003
  • https://postgrespro.com/blog/pgsql/5969884
  • https://www.cybertec-postgresql.com/en/which-partition-did-i-insert/
  • https://www.crunchydata.com/blog/postgres-strings-to-arrays-and-back-again
  • https://ente.io/blog/tech/postgres-queue/
  • https://www.cybertec-postgresql.com/en/grant-vacuum-analyze-postgresql-16/
  • https://www.crunchydata.com/blog/postgis-day-2022
  • https://postgres.fm/episodes/postgrest
  • https://postgresql.life/post/oleksandr_shulgin/
  • https://www.rubberduckdevshow.com/episodes/67-what-happens-after-rubycritic-with-ernesto-tagwerker/