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/