#280 — October 31, 2018

Read on the Web

Postgres Weekly

PostgreSQL Anonymizer: A Tool to Mask Personal Information — An introduction to a new Postgres extension for masking or replacing personally identifiable information (PII) which may be necessary for protecting commercially sensitive data or for complying with regulations like GDPR.

Damien Clochard

The Biggest Mistake Postgres Ever Made — A brief piece on confusion over the name of our favorite database, which some people call PostgreSQL, some Postgres, and some even Postgre.

Craig Kerstiens

Because Your Data Is Your Business — PostgreSQL Experts provides full-stack support for PostgreSQL, including database tuning, emergency support, and remote DBA services, including 24x7 support.

PostgreSQL Experts, Inc. sponsor

A 3 Part Series on Postgres Locking — An understanding of PostgreSQL locking is important to build scalable applications and avoid downtime. This series covers row locks, table-level locks and lightweight locks.

Nickolay Ihalainen

PipelineDB 1.0: An Extension for High-Perf Time-Series Aggregation — A Postgres extension for high-performance time-series aggregation via continuous SQL queries.

Derek Nelson

Postgres 12 To Introduce a pg_promote Function — With this new SQL-callable function, you’ll be able to promote a standby.

Hubert depesz Lubaczewski

The Evolution of Partitioning from Postgres 9.6 to 11 — Postgres partitioning first landed in 9.6. It has continued to get updates and now with newly released Postgres 11 is feature rich.

David Rowley (2ndQuadrant)

How to Set Up scram-sha-256 Authentication in Postgres

Quinn Weaver

Recreating a Column Oriented Database in Postgres — This is rather niche, but you may find this experiment in making Postgres act more like a column oriented DB interesting.

Brian Davis

Peeking at the Query Performance of Postgres 11

Kaarel Moppel

Announcing: EDB Postgres Migration Portal Beta 3 Release

EnterpriseDB sponsor

pgenv Gets Patching Supportpgenv is a utility to build and run different releases of Postgres and now supports customizable patching.

Luca Ferrari

🗓 Events

PGDay.Seoul 2018 November 3 (Seoul, South Korea) PostgreSQL Korean Users group prepared the third half day event. All presentations are in Korean.

Pg Down Under 2018 December 7 (Melbourne, Australia) PG Down Under 2018 is the second annual conference which provides a unique opportunity for PostgreSQL Developers and Users to meet, learn, grow relationships.

PGConf.ASIA 2018 December 10-12 (Tokyo, Japan) The largest PostgreSQL event in Asia.