Vacuum Speed Up, Faster Foreign Tables, Fast Queries With Union, Query Optimizer | Scaling Postgres 158
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/
Create your
podcast in
minutes
It is Free