Scaling Postgres

In this episode of Scaling Postgres, we discuss a vacuum speed up and faster foreign tables in Postgres 14, running faster queries with union and learning about the query optimizer. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.citusdata.com/blog/2021/03/25/speeding-up-recovery-and-vacuum-in-postgres-14/ http://postgres-road.blogspot.com/2021/03/faster-bulk-insertion-to-foreign-tables.html https://www.foxhound.systems/blog/sql-performance-with-union/ https://www.cybertec-postgresql.com/en/how-the-postgresql-query-optimizer-works/ https://www.highgo.ca/2021/03/20/how-to-check-and-resolve-bloat-in-postgresql/ https://www.depesz.com/2021/03/22/waiting-for-postgresql-14-allow-configurable-lz4-toast-compression/ https://www.citusdata.com/blog/2021/03/20/sharding-postgres-on-a-single-citus-node/ https://www.youtube.com/user/EnterpriseDB/videos https://blog.crunchydata.com/blog/get-started-with-explain-analyze https://www.e