Episode 203 Saving Space, Working with TOAST, Protecting Data, High CPU Utilization

<p>In this episode of Scaling Postgres, we discuss the new releases of Postgres, a hairy upgrade incident, why slowing down can make you go faster and using loadable modules for WAL archiving.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://www.depesz.com/2022/02/13/how-much-disk-space-you-can-save-by-using-int4-int-instead-of-int8-bigint/"> https://www.depesz.com/2022/02/13/how-much-disk-space-you-can-save-by-using-int4-int-instead-of-int8-bigint/</a></li> <li><a href= "https://blog.anayrat.info/en/2022/02/14/postgresql-toast-compression-and-toast_tuple_target/"> https://blog.anayrat.info/en/2022/02/14/postgresql-toast-compression-and-toast_tuple_target/</a></li> <li><a href= "https://blog.crunchydata.com/blog/safer-application-users-in-postgres"> https://blog.crunchydata.com/blog/safer-application-users-in-postgres</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-high-cpu-utilization-explain-plans-linux-perf"> https://pganalyze.com/blog/5mins-postgres-high-cpu-utilization-explain-plans-linux-perf</a></li> <li><a href= "https://www.highgo.ca/2022/02/18/the-significance-of-lsn-in-postgresql-system/"> https://www.highgo.ca/2022/02/18/the-significance-of-lsn-in-postgresql-system/</a></li> <li><a href= "https://dev.to/yugabyte/sqlcl-to-transfer-data-from-oracle-to-postgresql-or-yugabytedb-lha"> https://dev.to/yugabyte/sqlcl-to-transfer-data-from-oracle-to-postgresql-or-yugabytedb-lha</a></li> <li><a href= "https://postgrespro.com/blog/pgsql/5969262">https://postgrespro.com/blog/pgsql/5969262</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/pg_timetable-v4-4-is-available-immediately/"> https://www.cybertec-postgresql.com/en/pg_timetable-v4-4-is-available-immediately/</a></li> <li><a href= "https://postgresql.life/post/henrietta_dombrovskaya/">https://postgresql.life/post/henrietta_dombrovskaya/</a></li> <li><a href= "https://www.rubberduckdevshow.com/episodes/30-how-to-get-started-coding/">