Issue 356 - Comparing the ways to store binary data with Postgres (12)

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

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 😂

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.”

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.

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.

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

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.

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.

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

▶  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.

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

eBook: How to Get a 3x Performance Improvement on Your Postgres Database — The pganalyze team shares their best practices, learned over the last few years by helping companies like Atlassian optimize their Postgres databases.