In this episode of Scaling Postgres, we discuss a PG 14.4 release, how to skip transactions with logical replication, how to use schemas and Citus going fully open source.

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

Links for this episode:

• https://www.postgresql.org/about/news/postgresql-144-released-2470/
• https://www.postgresql.fastware.com/blog/addressing-replication-conflicts-using-alter-subscription-skip
• https://aaronoellis.com/articles/using-postgres-schemas
• https://www.citusdata.com/blog/2022/06/17/citus-11-goes-fully-open-source/
• https://www.cybertec-postgresql.com/en/case-insensitive-pattern-matching-in-postgresql/
• https://blog.brendanscullion.com/postgresql-text-search
• https://www.crunchydata.com/blog/quick-and-easy-postgres-data-compare
• https://sqlfordevs.io/uuid-prevent-enumeration-attack
• https://andreas.scherbaum.la/blog/archives/1113-My-PostgreSQL-database-is-empty!.html
• https://pganalyze.com/blog/5mins-postgres-reducing-aws-aurora-io-costs-table-partitioning-pruning
• https://www.migops.com/blog/oracle-vs-postgresql-transaction-control-statements/
• https://aws.amazon.com/blogs/database/handle-empty-strings-when-migrating-from-oracle-to-postgresql/
• https://postgresql.life/post/vigneshwaran_c/
• https://www.rubberduckdevshow.com/episodes/46-ractors-actors-for-ruby/