Issue 323 - Postgres 12 Beta 4 released (13)

PL/Proxy 2.9: Function-Based Sharding for Postgres — If you’re not familiar with the project, there’s more info on its homepage, but PL/Proxy was originally developed at Skype to help scale Postgres via sharding.

Tracking View Dependencies in Postgres — When you create complex structures involving tables, views, triggers, functions, etc. that rely upon each other, you create dependencies. Here’s an exploration of view dependencies and how to keep track of what views depend upon what other objects.

PostgreSQL 12 Beta 4 Released — Contains previews of all features that will be available in the final release of Postgres 12 and is “likely the final beta release” prior to a release candidate. As always, the beta release notes may be useful, as may Postgres’s How to Beta Test docs.

Learn PG 12 Features from Core Team Member — Join the free PostgreSQL webinar: New Features in PostgreSQL 12 with Peter Eisentraut and get an insider’s look into the upcoming PG 12 release.

Postgres Cheat Sheet — Basically 15 pages of quick solutions or approaches for a variety of Postgres-related tasks, from working with functions and users to constraints and interrogating tables.

Can You Gain Performance using Pgpool-II as a Load Balancer? — Spoiler: With a small number of clients, no. At much larger scale, yes. But, as always, it is worth running your own tests.

Partitioning is Faster in Postgres 12 — Many improvements have been made to partitioning in PostgreSQL 12. Here’s some benchmark results so you can see what’s been done.

Using DISTINCT ON in Non-Postgres Databases — We wrote about DISTINCT ON, a neat feature for selecting the first rows that distinctly match a variety of conditions, in our tip in issue 321. But what if you want to get a similar outcome on other database systems?

Why Use TimescaleDB Over Relational Databases? — The interesting thing is that while TimescaleDB is a time series database, it is built as an extension on top of a relational database, Postgres!

Installing Postgres 12 Beta/RC on RHEL, CentOS or Fedora — How to get testing the next version of Postgres on Red Hat flavored Linux distros.

The Data Loading Performance of Postgres and TimescaleDB — An experiment in testing the performance when loading a lot of data (over a billion rows) into Postgres and TimescaleDB running on EC2 instances.

Postgres Pager pspg 2.0.2 Released — We featured pspg two weeks ago, but its creator has since released two point releases that introduce sorting capabilities for all columns displayed.

See How Easy Managing Access to Postgres Can Be — Splunk's CISO says "strongDM lets you see what happened, replay and analyze incidents. You can't get that anywhere else."