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