New Release of PL/Proxy
PL/Proxy 2.9: Function-Based Sharding for Postgres — If you’re not familiar with the project, there’s more...
Pavel Stehule's blog: pspg 2.0.1 released
Postgres Pager pspg 2.0.2 Released — We featured pspg two weeks ago, but its creator has...
Data Loading Performance of Postgres and TimescaleDB
The Data Loading Performance of Postgres and TimescaleDB — An experiment in testing the performance when...
Devrim Gunduz's PostgreSQL Blog
Installing Postgres 12 Beta/RC on RHEL, CentOS or Fedora — How to get testing the next...
TimescaleDB Developer Docs
Why Use TimescaleDB Over Relational Databases? — The interesting thing is that while TimescaleDB is a...
Using DISTINCT ON in Non-PostgreSQL Databases
Using DISTINCT ON in Non-Postgres Databases — We wrote about DISTINCT ON, a neat feature for...
PostgreSQL 12: Partitioning is now faster - 2ndQuadrant | PostgreSQL
Partitioning is Faster in Postgres 12 — Many improvements have been made to partitioning in PostgreSQL...
Can you gain performance with Pgpool-II as a load balancer? – Highgo Software Inc.
Can You Gain Performance using Pgpool-II as a Load Balancer? — Spoiler: With a small number...
Postgres Cheatsheet
Postgres Cheat Sheet — Basically 15 pages of quick solutions or approaches for a variety of...
Webinar: New Features in PostgreSQL 12
Learn PG 12 Features from Core Team Member — Join the free PostgreSQL webinar: New Features...
PostgreSQL: PostgreSQL 12 Beta 4 Released!
PostgreSQL 12 Beta 4 Released — Contains previews of all features that will be available in...
Tracking view dependencies in PostgreSQL - Cybertec
Tracking View Dependencies in Postgres — When you create complex structures involving tables, views, triggers, functions,...
Replicating PostgreSQL into MemSQL's Columnstore - MemSQL Blog
Replicating PostgreSQL into MemSQL's Columnstore — How to get the high performance of MemSQL’s columnstore for...
How to Deploy and Manage PostgreSQL on OpenShift using the ROBIN Operator – Red Hat OpenShift Blog
How to Deploy and Manage Postgres on OpenShift using the ROBIN Operator
What is an SQL relation?
What is an SQL 'Relation'? — This is a short but sweet introduction to the concept...
Managing PostgreSQL users and roles | Amazon Web Services
Managing Postgres Users and Roles — This is a few months old but we missed it...
EDB.
A Discussion of High Availability Options for Postgres in Containers — Clustered containers running Postgres require...