Issue 317 - Ever wanted to create a Postgres extension in C? (12)

How to Display the Encoded Byte Stream of a VARCHAR Column — I can’t think of a situation I’d use it, but an interesting bit of SQL nonetheless.

How Postgres Can Not Be 'Bought Out' — While MySQL was an open source database, Oracle still essentially managed to take the project over by acquiring its parent company. This can’t happen with Postgres.

Barman 2.9: The Backup and Recovery Management Tool — This release introduces native support for the forthcoming Postgres 12, which includes major changes in the way Point-In-Time-Recovery and Replicas are managed.

The Absolute Beginner's Guide to Creating a Postgres Extension with C — Postgres makes itself relatively easy to extend by way of extensions, most commonly built in C. This quick walkthrough shows how to set up a really basic extension development project and get it working.

Comparing Postgres's JSONB with Couchbase — Can Postgres really take the place of a ‘NoSQL’ document-oriented database? It’s interesting to see something like this from a document-oriented database vendor, especially as it’s reasonably fair to Postgres (while still focusing on Couchbase’s strengths, naturally).

Postgres vs MongoDB Benchmarking: 'Do It with Transparency or Don't Do It At All' — There’s been a bit of a dramatic ‘back and forth’ between Ongres and MongoDB recently over a benchmark which showed Postgres ‘dominating’ MongoDB in certain workloads. MongoDB responded with a call to ‘do it right’ to which Ongres have doubled down with a strong defense and a promise of...

Postgres Gets an O'Reilly Open Source Award for 'Lifetime Achievement' — It feels weird for a project to get a ‘lifetime’ award, but good news nonetheless! Mark Wong, Bruce Momjian and Christophe Pettus accepted the award at O’Reilly’s OSCON event on behalf of the PostgreSQL project.

Examining Postgres's Support for Pattern Matching with Regular Expressions — A regular expression (known as regexes in plural) is a sequence of characters that describes a textual search pattern. Postgres supports a few ways to use regexes and this first in a promised series of posts touches on POSIX regex support.

How to Adjust Linux's Out-Of-Memory Killer Settings for Postgres — The Out-Of-Memory ‘Killer’ is responsible for terminating applications in order to reclaim memory and prevent the kernel from crashing. Here are some suggestions to keep it out of Postgres’s way.

Using plpgsql_check to Find Compilation Errors and Profile Functions — An interesting project called plpgsql_check can be used similarly to plprofiler while also looking at PL/pgSQL code and pointing out compilation errors.

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.

Metrics to Monitor in Your PostgreSQL Database — There are several key metrics you’ll want to keep track of when it comes to database performance, and they’re not all database-specific.