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-could-not-set-compression.html
• https://www.cybertec-postgresql.com/en/btree-vs-brin-2-options-for-indexing-in-postgresql-data-warehouses/
• https://www.crunchydata.com/blog/postgres-indexing-when-does-brin-win
• https://www.enterprisedb.com/blog/new-public-schema-permissions-postgresql-15
• https://www.percona.com/blog/postgresql-are-all-nulls-the-same/
• https://www.percona.com/blog/securing-patroni-rest-api-end-points-part-1/
• https://www.crunchydata.com/blog/data-loading-in-postgres-for-newbies
• https://postgres.fm/episodes/version-control-for-databases
• https://postgresql.life/post/adrien_nayrat/
• https://www.rubberduckdevshow.com/episodes/64-where-to-put-your-business-logic-with-jason-charnes/