Scaling Postgres

External Compression, Parallel Vacuum, JSON Aggregates, JSON & Arrays | Scaling Postgres 130

Informações:

Synopsis

In this episode of Scaling Postgres, we discuss external compression, vacuuming in parallel, working with JSON Aggregates and the JSON & Array datatypes. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://amitdkhan-pg.blogspot.com/2020/08/need-for-external-compression-methods.html https://www.2ndquadrant.com/en/blog/parallelism-comes-to-vacuum/ https://blog.k-nut.eu/postgres-json-aggregate-functions https://www.2ndquadrant.com/en/blog/webinar-json-array-contemporary-postgresql-data-types-follow-up/ https://www.2ndquadrant.com/en/blog/how-to-get-the-best-out-of-postgresql-logs/ https://www.cybertec-postgresql.com/en/postgresql-vs-postgresql-vs-postgre-vs-oracle-vs-all-the-rest/ https://www.2ndquadrant.com/en/blog/oracle-to-postgresql-cursors-and-ltrees/ https://info.crunchydata.com/blog/three-easy-things-to-remember-about-postgres-indexes https://severalnines.com/database-blog/overview-trusted-extensions-postgresql-13 https