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.dolthub.com/blog/2022-01-26-creating-a-postgres-foreign-data-wrapper/
- https://www.endpointdev.com/blog/2022/01/regex-group-quantifiers-postgresql/
- https://postgresql.life/post/alvaro_herrera/
- https://www.rubberduckdevshow.com/episodes/28-exploring-jamstack/