In this episode of Scaling Postgres, we discuss a severe bug with index creation in Postgres 14, view permissions options, dealing with logical replication conflicts and looking under the hood of AlloyDB.

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

Links for this episode:

  • https://pganalyze.com/blog/5mins-postgres-14-reindex-create-index-concurrently-bug-amcheck-extension
  • https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=042b584c7f7d6216c54359c0ee0f613ba3b3d9c2
  • https://www.postgresql.org/docs/14/amcheck.html
  • https://www.cybertec-postgresql.com/en/view-permissions-and-row-level-security-in-postgresql/
  • https://www.postgresql.fastware.com/blog/how-to-handle-logical-replication-conflicts-in-postgresql
  • https://cloud.google.com/blog/products/databases/alloydb-for-postgresql-intelligent-scalable-storage
  • https://cloud.google.com/blog/products/databases/alloydb-for-postgresql-columnar-engine
  • https://www.enterprisedb.com/blog/using-virtual-environment-plpython3-postgresql
  • https://www.enterprisedb.com/blog/new-order-and-limit-offset-pushdown-features-increase-agility-mysqlfdw
  • https://www.crunchydata.com/blog/effective-postgres-cluster-config-and-management-using-pgo-v5.1
  • https://postgresql.life/post/virginie_jourdan/
  • https://www.rubberduckdevshow.com/episodes/44-reviewing-2022-rails-community-survey/