Scaling Postgres

In this episode of Scaling Postgres, we discuss how sequential scans can be forced, the best way to rename a table without downtime, different Postgres terminology and the PGSQL Phriday blogging event. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://code.jeremyevans.net/2022-11-01-forcing-sequential-scans-on-postgresql.html https://pganalyze.com/blog/5mins-postgres-large-integers-causing-sequential-scan-instead-of-using-index https://brandur.org/fragments/postgres-table-rename https://www.crunchydata.com/blog/challenging-postgres-terminology https://andreas.scherbaum.la/blog/archives/1122-PGSQL-Phriday-002-PostgreSQL-Backup-and-Restore.html https://blog.rustprooflabs.com/2022/11/pgsql-phriday-002 https://mydbanotebook.org/post/how-to-do-proper-backups/ https://www.scarydba.com/2022/11/04/validating-backups-pgsql-phriday-002/ https://www.softwareandbooz.com/adventures-in-postgresql-backups/ http://rhaas.blogspot.com/2022/11/pgbasebackup-coul