Insert vs. Update, Select * Performance, Debezium Set Up, Standardizing Data | Scaling Postgres 142
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://info.crunchydata.com/blog/waiting-for-postgis-3.1-grid-generators
https://postgresql.life/post/pavel_stehule/
Create your
podcast in
minutes
It is Free