Scaling Postgres

In this episode of Scaling Postgres, we discuss inserts vs. updates, select * performance, how to set up Debezium and methods to standardize data. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/insert-only-data-modelling-to-smooth-peaks-on-slow-disks/ https://tanelpoder.com/posts/reasons-why-select-star-is-bad-for-sql-performance/ https://elephanttamer.net/?p=50 https://info.crunchydata.com/blog/postgres-the-batteries-included-database https://info.crunchydata.com/blog/using-postgresql-for-statistics-centering-and-standardizing-data https://www.highgo.ca/2020/11/26/postgresql-high-availability-setup-and-uptime-considerations/ https://www.citusdata.com/blog/2020/11/21/making-postgres-stored-procedures-9x-faster-in-citus/ https://pgstef.github.io/2020/11/21/combining_pgbackrest_dedicated_repository_host_and_streaming_replication.html https://www.pgbouncer.org/2020/11/pgbouncer-1-15-0 https://i