Scaling Postgres

Saving Space, Working with TOAST, Protecting Data, High CPU Utilization | Scaling Postgres 203

Informações:

Synopsis

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. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.depesz.com/2022/02/13/how-much-disk-space-you-can-save-by-using-int4-int-instead-of-int8-bigint/ https://blog.anayrat.info/en/2022/02/14/postgresql-toast-compression-and-toast_tuple_target/ https://blog.crunchydata.com/blog/safer-application-users-in-postgres https://pganalyze.com/blog/5mins-postgres-high-cpu-utilization-explain-plans-linux-perf https://www.highgo.ca/2022/02/18/the-significance-of-lsn-in-postgresql-system/ https://dev.to/yugabyte/sqlcl-to-transfer-data-from-oracle-to-postgresql-or-yugabytedb-lha https://postgrespro.com/blog/pgsql/5969262 https://www.cybertec-postgresql.com/en/pg_timetable-v4-4-is-available-immediately/ https://postgresql.life/post/henrietta_dombrovskaya/ https://www.ru