
Episode 240 Forced Sequential Scans, Table Renaming, Terminology, PGSQL Phriday
Bikking
Description
<p>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.</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://code.jeremyevans.net/2022-11-01-forcing-sequential-scans-on-postgresql.html"> https://code.jeremyevans.net/2022-11-01-forcing-sequential-scans-on-postgresql.html</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-large-integers-causing-sequential-scan-instead-of-using-index"> https://pganalyze.com/blog/5mins-postgres-large-integers-causing-sequential-scan-instead-of-using-index</a></li> <li><a href= "https://brandur.org/fragments/postgres-table-rename">https://brandur.org/fragments/postgres-table-rename</a></li> <li><a href= "https://www.crunchydata.com/blog/challenging-postgres-terminology"> https://www.crunchydata.com/blog/challenging-postgres-terminology</a></li> <li><a href= "https://andreas.scherbaum.la/blog/archives/1122-PGSQL-Phriday-002-PostgreSQL-Backup-and-Restore.html"> https://andreas.scherbaum.la/blog/archives/1122-PGSQL-Phriday-002-PostgreSQL-Backup-and-Restore.html</a></li> <li><a href= "https://blog.rustprooflabs.com/2022/11/pgsql-phriday-002">https://blog.rustprooflabs.com/2022/11/pgsql-phriday-002</a></li> <li><a href= "https://mydbanotebook.org/post/how-to-do-proper-backups/">https://mydbanotebook.org/post/how-to-do-proper-backups/</a></li> <li><a href= "https://www.scarydba.com/2022/11/04/validating-backups-pgsql-phriday-002/"> https://www.scarydba.com/2022/11/04/validating-backups-pgsql-phriday-002/</a></li> <li><a href= "https://www.softwareandbooz.com/adventures-in-postgresql-backups/"> https://www.softwareandbooz.com/adventures-in-postgresql-backups/</a></li> <li><a href= "http://rhaas.blogspot.com/2022/11/pgbasebackup-could-not-set-compression.html"> http://rhaas.blogspot.com/2022/11/pgbasebackup-could-not-set-compression.html</a