External Compression, Parallel Vacuum, JSON Aggregates, JSON & Arrays | Scaling Postgres 130
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/
Create your
podcast in
minutes
It is Free