Scaling Postgres

JSONB Performance, Bidirectional Replication, Most Recent Record, PG14 JSON | Scaling Postgres 201

Informações:

Synopsis

In this episode of Scaling Postgres, we discuss JSONB performance, bidirectional replication, getting the most recent record and using JSON in Postgres 14. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.evanjones.ca/postgres-large-json-performance.html https://pganalyze.com/blog/5mins-postgres-jsonb-toast https://www.enterprisedb.com/blog/pg-phriday-nominally-bidirectional https://blog.timescale.com/blog/select-the-most-recent-record-of-many-items-with-postgresql/ https://aaronbos.dev/posts/postgres-14-json https://www.postgresql.fastware.com/blog/how-to-gain-insight-into-the-pg-stat-replication-slots-view-by-examining-logical-replication https://www.cybertec-postgresql.com/en/automatic-partition-creation-in-postgresql/ https://blog.crunchydata.com/blog/secure-permissions-for-pgbackrest https://blog.yugabyte.com/postgresql-timestamps-timezones/ https://blog.yugabyte.com/postgresql-timestamps-timezones-interval-minefield/ https://www.do