Issue 325 - Postgres 12 is imminent (13)

Postgres 12 RC 1 Released, Final Due This Week? — The first release candidate of PostgreSQL 12 is now available for download. The final release is expected tomorrow, but we didn’t feel it was 100% enough to delay this issue but it will be on postgresql.org as soon as it’s out.

On Implementing Transparent Data Encryption in Postgres — A brief update on a long term discussion over whether (and how) Postgres should implement TDE. In short, work is now underway, with work on this TODO list hoping to be in place for Postgres 13.

Hacker News Discusses.. Postgres or MySQL? — There’s little more that can provoke a discussion on Hacker News than asking readers to choose between two technologies. Perhaps unsurprisingly, Postgres seems to be strongly preferred.

Introducing phpPgAdmin 7.12.0 — phpPgAdmin is a Web-based Postgres administration tool (in a similar vein to MySQL’s popular phpMyAdmin). v7.12.0 moves to PHP 7 and supports all current versions of Postgres (including 12).

PostGIS 3.0 Beta 1 Released — Best used with Postgres 12, PostGIS is a popular Postgres extension that opens up the world of working with geospatial data at an advanced level from right within your database.

How to Run a Quick ALTER TABLE Without Long Locking Concurrent Queries — An interesting workaround to a confusing problem.

How to Work with Postgres in Go(lang) — An attempt at ‘arming you with experience’ of using PostgreSQL from Go (with pgx, specifically), covering tools, drivers, logging, monitoring, and quirks to look out for.

Fixing track_activity_query_size in postgresql.conf — By default, Postgres reserves up to 1024 bytes to track each query run which might not be enough for your monitoring or logging preferences. Here’s how to tweak the setting involved.

Is Synchronous Replication a Trap? — “I think that a lot of people are using this technology and getting little or no benefit out of it, and some are actively hurting themselves.”

Take the Guesswork Out of Improving Query Performance — Based on the query plan, pgMustard offers you tips to make your query faster. Try it for free.

How Much Faster is Redis at Storing a Blob of JSON Compared to Postgres? — If you’re familiar with Redis, the in-memory data structure store, it won’t surprise you that it’s fast(!) but the use cases and pros and cons between Redis and Postgres are hugely different too.

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.