Issue 453 - AWS's 1 terabyte of RAM for Postgres (13)

A Look at (Future) Parallel Server-Side Backup Compression — 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!

▶  IO in Postgres: Past, Present, and Future — 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.)

Is Your Distributed Database Really 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.

Working with Large Postgres 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.

Apache AGE 1.0: A Graph Extension for Postgres — An extension that provides graph database functionality (via openCypher) to Postgres and was inspired by AgensGraph. More info on the release.

Analyzing Historical Flight Data with 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.

Using SQL's MERGE in Postgres 15 — Last month, we mentioned that MERGE support is coming to Postgres 15 and this post presents a basic example of its use.

▶  Advanced Postgres Schema Design — 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.”

Automating Interval Partitioning Maintenance on Amazon RDS or Aurora — Very AWS specific but there’s a lot of tying together ideas here for creating robust partitioned databases.

pgwatch2 v1.9 Final Released — pgwatch2 is a Postgres monitoring system using Grafana dashboards for visualization of a wide array of Postgres metrics.

Custom Dashboards, Admin Panels, CRUD Apps — Build an Internal Tool on Any SQL Database 10x Faster

pg_ivm 1.0: IVM (Incremental View Maintenance) Extension — 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.