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 écoutes0 favoris
Business & Finance
Lire

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

Créateurs

pip_flow

pip_flow

Creator