Scaling Postgres

UUIDs, Write Spikes, Distinct, SQL Standard | Scaling Postgres 23

Informações:

Synopsis

In this episode of Scaling Postgres, we review articles covering UUIDs, the source of write spikes, uses of distinct and SQL standards support. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: http://richardstartin.uk/uuids-and-compressibility/   https://medium.com/cermati-tech/troubleshooting-daily-write-spikes-on-cermatis-postgresql-rds-9016d7a0c2e4   https://www.citusdata.com/blog/2018/07/25/high-performance-distributed-dml/   https://medium.com/statuscode/the-many-faces-of-distinct-in-postgresql-c52490de5954   https://modern-sql.com/slides/PG-stays-ahead-20180718.pdf   https://tapoueh.org/blog/2018/07/batch-updates-and-concurrency/   https://info.crunchydata.com/blog/wheres-my-replica-troubleshooting-streaming-replication-synchronization-in-postgresql