--- title: "AWS's 1 terabyte of RAM for Postgres" publication: "Postgres Weekly" issue: 453 published_at: "2022-05-04" canonical_url: "https://postgresweekly.com/issues/453" --- Plus a deep dive into IO in Postgres, AGE 1.0 is released, and plotting flight paths with MobilityDB. | #​453 — May 4, 2022 [Web Version](https://postgresweekly.com/issues/453) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/lljednvtgyp6bvwqzpyw.jpg)](http://rhaas.blogspot.com/2022/05/parallel-server-side-backup-compression.html) [A Look at (Future) Parallel Server-Side Backup Compression](http://rhaas.blogspot.com/2022/05/parallel-server-side-backup-compression.html) — Postgres 15 will, fingers crossed, support server-side backup compression and Robert did a little digging around to see how well it might work (in terms of both speed and disk space saved) using different compression algorithms. Very promising! Robert Haas ▶[IO in Postgres: Past, Present, and Future](https://www.youtube.com/watch?v=3Oj7fBAqVTw) — A technical talk given just two days ago digging deep into Postgres’s IO story including the current limitations, how those limitations are being worked around, and progress being made on improvements. _(1 hour 6 minutes.)_ Andres Freund [![\](https://copm.s3.amazonaws.com/870b7dc2.png)](https://blog.yugabyte.com/is-your-distributed-database-postgresql-compatible/) [Is Your Distributed Database Really PostgreSQL Compatible?](https://blog.yugabyte.com/is-your-distributed-database-postgresql-compatible/) — How do you evaluate the PostgreSQL compatibility of cloud native databases? This video provides a framework for comparing PostgreSQL compatibility of modern databases, including Google Spanner, Amazon Aurora, CockroachDB, and YugabyteDB. YugabyteDB sponsor [Working with Large Postgres Databases](https://www.percona.com/blog/working-with-large-postgresql-databases/) — What _is_ a small, medium, or large database when Postgres can handle up to an unlimited size (though tables are limited to 32TB)? Addressing potential issues for a ‘large’ database by anticipating future conditions is the goal for every DBA, says Robert. Robert Bernier [Apache AGE 1.0: A Graph Extension for Postgres](https://age.apache.org/) — An extension that provides graph database functionality (via openCypher) to Postgres and was inspired by AgensGraph. [More info](https://www.postgresql.org/about/news/announcing-the-release-of-apache-ageincubating-100-2444/) on the release. Apache Foundation **In brief:** - [A look into the details](https://www.wiz.io/blog/wiz-research-discovers-extrareplica-cross-account-database-vulnerability-in-azure-postgresql/) of a cross-account database vulnerability that was found in Azure PostgreSQL. - Amazon RDS for PostgreSQL [now supports new M6i and R6i instances](https://aws.amazon.com/about-aws/whats-new/2022/04/amazon-rds-postgresql-supports-m6i-r6i-instances/) that offer up to 128 vCPUs and 1TB of RAM. Could your startup now keep all its data in RAM on AWS? Possibly, if you have a few thousand dollars a month for it. [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ntcwgebrygym314mm7qb.jpg)](https://www.cybertec-postgresql.com/en/analyzing-historical-flight-data-with-mobilitydb/) [Analyzing Historical Flight Data with MobilityDB](https://www.cybertec-postgresql.com/en/analyzing-historical-flight-data-with-mobilitydb/) — [MobilityDB](https://github.com/MobilityDB/MobilityDB) sits atop Postgres and PostGIS for providing geospatial _trajectory_ analysis.. so it’s perfect for analyzing historical air traffic data, as demonstrated here. Florian Nadler [Using SQL's `MERGE` in Postgres 15](https://www.cybertec-postgresql.com/en/postgresql-15-using-merge-in-sql/) — Last month, we mentioned that [MERGE](https://www.postgresql.org/docs/devel/sql-merge.html) support is coming to Postgres 15 and this post presents a basic example of its use. Hans-Jürgen Schönig ▶[Advanced Postgres Schema Design](https://www.youtube.com/watch?v=lkWiyEe2RUQ) — A talk from PGConf NYC 2021 on going _“beyond `CREATE TABLE` and `CREATE VIEW` with functional indexes, exclusion constraints, array types, transactional DDL, and more.”_ Sehrope Sarkuni [Automating Interval Partitioning Maintenance on Amazon RDS or Aurora](https://aws.amazon.com/blogs/database/automate-interval-partitioning-maintenance-and-monitoring-in-amazon-rds-for-postgresql-and-amazon-aurora-postgresql/) — Very AWS specific but there’s a lot of tying together ideas here for creating robust partitioned databases. Shetty, Gudivada, et al. (AWS) [Tuning Auto-Vacuuming Parameters](https://vettabase.com/blog/tuning-postgresql-auto-vacuum/) — The most perennial Postgres topic there is, perhaps. Michael Aboagye [How to Upgrade Postgres from 13 to 14 on Ubuntu 22.04](https://www.paulox.net/2022/04/28/upgrading-postgresql-from-version-13-to-14-on-ubuntu-22-04-jammy-jellyfish/) Paolo Melchiorre **🔧 Code and Tools:** [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/d8inwxbcrn3hxdojzzgs.jpg)](https://www.cybertec-postgresql.com/en/pgwatch2-v1-9-final-release/) [pgwatch2 v1.9 Final Released](https://www.cybertec-postgresql.com/en/pgwatch2-v1-9-final-release/) — [pgwatch2](https://pgwatch2.readthedocs.io/en/latest/README.html) is a Postgres monitoring system using Grafana dashboards for visualization of a wide array of Postgres metrics. Pavlo Golub [Custom Dashboards, Admin Panels, CRUD Apps — Build an Internal Tool on Any SQL Database 10x Faster](https://retool.com/?utm_source=sponsor&utm_medium=newsletter&utm_campaign=cooperpress) Retool sponsor [pg_ivm 1.0: IVM (Incremental View Maintenance) Extension](https://github.com/sraoss/pg_ivm) — Incremental View Maintenance (IVM) keeps materialized views up to date in a way where incremental changes are computed and applied rather than recomputing everything. pg_ivm provides a kind of ‘immediate maintenance’ where materialized views are updated immediately after a base table is modified. SRA OSS, Inc. Japan **Got a new email?** You can [change your address here](https://postgresweekly.com/edit_subscription/*|UID|*). --- **Bored of us?** [Click here to stop getting Postgres Weekly](https://postgresweekly.com/leave/*|UID|*). --- **Got a link for us?** Reply and tell us. We can't include everything but we'll look at anything you send. Thanks! --- Published by Cooper Press Ltd. Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom Postgres, PostgreSQL and the Slonik Logo are trademarks or registered trademarks of the PostgreSQL Community Association of Canada. [Stop getting this newsletter.](https://postgresweekly.com/leave/*|UID|*)