#356 — May 20, 2020

Read on the Web

Postgres Weekly

Comparing Binary Data Performance in Postgres — You can store large binary blogs outside your database and reference them, store them as ‘large objects’, or use bytea byte arrays. How do they compare? This is an important thing to consider if you do have binary blobs flying around in your data model. BTW, I’m loving Laurenz’s lo-fi post illustrations lately 😂

Laurenz Albe

The Draft Postgres 13 Release Notes — As Bruce Momjian wrote: “I have completed the draft version of the Postgres 13 release notes, containing 181 items. The release notes will be continually updated until the final release, which is expected to be in September or October of this year.”

PostgreSQL Global Development Group

Kubernetes Operators for Highly Available PostgreSQL and BDR — Ground-breaking design with up to 7x faster performance and negligible overhead on bare metal; easy setup and superior user experience. Developed for mission critical databases with high security requirements. Backed by 24/7 Support for production use.

2ndQuadrant PostgreSQL Products sponsor

PostgreSQL 12.3, 11.8, 10.13, 9.6.18, and 9.5.22 Released — Fixes 75 bugs reported since the last mass release, but one key Windows-only security issue.

PostgreSQL Global Development Group

▶  Discussing Index Corruption in Postgres — Two developers at EnterpriseDB discuss database corruption and how corrupt indexes are not always as obvious as corrupt tables.

Postgres Pulse

How to Count Hits on a Web Site in Postgres — If you want to be accurate, it’s all matter of handling concurrency. A rather elaborate solution is on offer here.

Hans-Jürgen Schönig

An Interview with Dimitri Fontaine — Dimitri, of The Art of PostgreSQL fame, is this person’s PostgreSQL Person of the Week and faces the usual questions about his work with Postgres, his top Postgres annoyance, etc.

Andreas Scherbaum

Building PostgreSQL and Extensions on Windows from Scratch — Yep, you can compile Postgres and extensions using Visual Studio 2019. Here’s how.

David Zhang

Free eBook: How to Get a 3x Performance Improvement on Your Postgres Database — Learn our best practices for optimizing Postgres query performance for customers like Atlassian and how to reduce data loaded from disk by 500x.

pganalyze sponsor

▶  Powering Up Postgres Analytics with Swarm64 — A few weeks ago we featured news about Swarm64, a Postgres “acceleration” system. This podcast interviews Swarm64 CEO Thomas Richter about optimizing Postgres on high performance hardware and even FPGAs for analytical workloads.

The Data Engineering Podcast podcast

How to Use pgBadger to Solve Query Performance IssuespgBadger is a Postgres log analyzer which you can use to surface data about where your Postgres server is running into performance issues.

Mohini Ogale and Amit Sharma

Using MQTT as a Transport for Postgres Messages — MQTT has become a de-facto standard for the transport of messages between IoT devices.


🗓 Upcoming Online Events

  • Postgres Pulse - weekly at 11am ET each Monday. Weekly Zoom-based sessions with folks like Bruce Momjian, Vibhor Kumar, and other people at EnterpriseDB.
  • Postgres Vision 2020 on June 23-24. A full attempt at an online Postgres conference across multiple days with multiple tracks.