#280 — October 31, 2018 |
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 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 |
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. |