Scaling Postgres

PG14 Index Bug, View Permissions, Logical Replication Conflicts, AlloyDB Under the Hood | Scaling Postgres 218

Informações:

Synopsis

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