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

YouTube Video