Episode 158 Vacuum Speed Up | Faster Foreign Tables | Fast Queries With Union | Query Optimizer

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <p><a href= "https://www.citusdata.com/blog/2021/03/25/speeding-up-recovery-and-vacuum-in-postgres-14/"> https://www.citusdata.com/blog/2021/03/25/speeding-up-recovery-and-vacuum-in-postgres-14/</a><br /> <br /> <a href= "http://postgres-road.blogspot.com/2021/03/faster-bulk-insertion-to-foreign-tables.html"> http://postgres-road.blogspot.com/2021/03/faster-bulk-insertion-to-foreign-tables.html</a><br /> <br /> <a href= "https://www.foxhound.systems/blog/sql-performance-with-union/">https://www.foxhound.systems/blog/sql-performance-with-union/</a><br /> <br /> <a href= "https://www.cybertec-postgresql.com/en/how-the-postgresql-query-optimizer-works/"> https://www.cybertec-postgresql.com/en/how-the-postgresql-query-optimizer-works/</a><br /> <br /> <a href= "https://www.highgo.ca/2021/03/20/how-to-check-and-resolve-bloat-in-postgresql/"> https://www.highgo.ca/2021/03/20/how-to-check-and-resolve-bloat-in-postgresql/</a><br /> <br /> <a href= "https://www.depesz.com/2021/03/22/waiting-for-postgresql-14-allow-configurable-lz4-toast-compression/"> https://www.depesz.com/2021/03/22/waiting-for-postgresql-14-allow-configurable-lz4-toast-compression/</a><br /> <br /> <a href= "https://www.citusdata.com/blog/2021/03/20/sharding-postgres-on-a-single-citus-node/"> https://www.citusdata.com/blog/2021/03/20/sharding-postgres-on-a-single-citus-node/</a><br /> <br /> <a href= "https://www.youtube.com/user/EnterpriseDB/videos">https://www.youtube.com/user/EnterpriseDB/videos</a><br /> <br /> <a href= "https://blog.crunchydata.com/blog/get-started-with-explain-analyze"> https://blog.crunchydata.com/blog/get-started-with-explain-analyze</a><br /> <br /> <a href= "https://www.enterprisedb.com/blog/ansible-collection-postgre