#​401 — April 14, 2021

Web Version

Postgres Weekly

Cleaning Up a Large Number of BLOBs in Postgres — No, not deadly blobs from outer space but ‘binary large objects.’ Many engineers are against storing large binary data in the database at all, but when you need to, there are some ways to make the process more efficient with Postgres.

Hans-Jürgen Schönig

Is Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL a Better Choice for Me? — I think there’s a lot of confusion about when Aurora or straight RDS suit the situation. Here, Amazon attempts to clarify things.

Vivek Singh and Sagar Patel (AWS)

⚡ 13 Tips to Improve PostgreSQL Inserts — Get our favorite ways to speed up PG ingest rate, from how to test and optimize disk performance to using parallel writes, batch inserts, and more. Faster database, faster queries 🚀

Timescale sponsor

Apache AGE 0.4: A Graph Extension for Postgres — An extension that provides graph database functionality to Postgres and was inspired by AgensGraph. The latest release (0.4.0) adds a variety of small syntax level features. GitHub repo.

Apache Foundation

How to Run Hierarchical Queries — A demonstration of querying hierarchical structures represented in standard tables first by looking at the Oracle approach and then moving to the use of CTEs in Postgres.

Ahsan Hadi

Quick Bits

  • The State of Postgres 2021 survey closes this Friday (April 16) so take it before then if you want to.
  • The Postgres 14 branch has now entered 'feature freeze' meaning that any new features that could be in Postgres 14 are now committed (even if not completed).

Shared Memory Sizing — Postgres 13 added pg_shmem_allocations, a way to get a detailed look at Postgres’ use of and size of allocated shared memory.

Bruce Momjian

Managing Transaction ID Exhaustion and Wraparound — Transaction ID wraparound has led to problems for many a Postgres administrator in the past. This post looks at a way to monitor for it and mitigate the problem.

Keith Fiske

State of Internal Tools Report 2021 — We surveyed 650 developers on how and why they build internal apps. Find out the most popular tools and databases.

Retool sponsor

Getting Started with QGIS, Postgres and PostGIS — A quick introduction to setting up PostGIS and QGIS, a desktop app for viewing, editing and analyzing geospatial data, to view OpenStreetMap data.

Hans-Jürgen Schönig

An Interview with EDB's Devrim Gündüz — Andreas continues with the ‘PostgreSQL Person of the Week’ series and it’s great to learn a bit more about people in our community. Devrim has been working with Postgres for 22 years.

Andreas Scherbaum

How to Schedule Jobs in Amazon RDS for PostgreSQL using AWS CodeBuild and Amazon EventBridge

Suresh Moolya (AWS)