Episode 201 JSONB Performance, Bidirectional Replication, Most Recent Record, PG14 JSON
Episode 201 JSONB Performance, Bidirectional Replication, Most Recent Record, PG14 JSON

Episode 201 JSONB Performance, Bidirectional Replication, Most Recent Record, PG14 JSON

Bikking

15 min0 plays0 favorites
Business & Finance
Play

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

Creators

pip_flow

pip_flow

Creator