Search

Home > Scaling Postgres > Episode 158 Vacuum Speed Up | Faster Foreign Tables | Fast Queries With Union | Query Optimizer
Podcast: Scaling Postgres
Episode:

Episode 158 Vacuum Speed Up | Faster Foreign Tables | Fast Queries With Union | Query Optimizer
Category: Technology
Duration: 00:19:49
Publish Date: 2021-03-28 21:43:55
Description:

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.enterprisedb.com/blog/ansible-collection-postgresql-and-edb-components https://mydbanotebook.org/post/no_space_left_on_device/ https://blog.crunchydata.com/blog/performance-improvements-in-geos https://www.enterprisedb.com/blog/how-get-status-cloud-native-postgresql-cluster https://postgresql.life/post/julien_riou/
Total Play: 0