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://www.highgo.ca/2020/09/03/postgresql-backups/

https://pgstef.github.io/2020/09/04/combining_pgbackrest_and_streaming_replication.html

https://postgresql.life/post/marco_slot/