Scaling Postgres Episode 142 Insert vs. Update | Select * Performance | Debezium Set Up | Standardizing Data

In this episode of Scaling Postgres, we discuss inserts vs. updates, select * performance, how to set up Debezium and methods to standardize data.

Content Discussed

Insert-only data modelling to smooth peaks on slow disks
Reasons why SELECT * is bad for SQL performance
Setting up PostgreSQL for Debezium
Using Postgres for Statistics: Centering and Standardizing Data
Postgres: The batteries included database
PostgreSQL High Availability: Setup and Uptime Considerations
Making Postgres stored procedures 9X faster in Citus
Combining pgBackRest dedicated repository host and Streaming Replication
PgBouncer 1.15.0
Waiting for PostGIS 3.1: Grid Generators
Pavel Stehule