#284 — December 5, 2018

Read on the Web

Postgres Weekly

What's New in PostgreSQL 11 — Postgres 11 landed about 6 weeks ago but in case you haven’t played with it yet, this post gives an overview of the new features and functions.

Viorel Tabara

Transactions in PostgreSQL: READ COMMITTED vs. REPEATABLE READ — The SQL standard proposes different transaction isolation levels (e.g. READ COMMITTED and REPEATABLE READ) to control the behavior of the database engine with regards to reading data being committed in concurrently running transactions.

Hans-Jürgen Schönig

Announcing The EDB Postgres Cloud Database Service Beta — A complete managed service, delivering enterprise-ready EDB Postgres databases on the Amazon Web Services (AWS) Cloud.

EnterpriseDB sponsor

Installing and Configuring JIT in Postgres 11 — Just-In-Time (JIT) compilation for SQL statements came to Postgres 11 as an option to Postgres 11 but as not all workloads can benefit from it, it’s not enabled by default. Here’s how you can get it running to see if it benefits you.

Jobin Augustine

AgensGraph 2.0: A Multi-Model Graph Database for Postgres — AgensGraph is a graph database (supporting both SQL and Cypher queries) built atop Postgres. GitHub repo.

Bitnine

psql on Postgres 12 Gains Simple CSV Output Feature

Pavel Stěhule

Combining pgBackRest and Streaming ReplicationpgBackRest is a powerful backup and restore tool for Postgres.

Stefan Fercot

Postgres 12 Feature Highlight: DOS Prevention — It’s possible to lock up a Postgres database with certain queries, and fixes are on the way in Postgres 12.

Michael Paquier

PostgreSQL Streaming Physical Replication With Slots — Physical Postgres replication is based around the Write Ahead Log (WAL) and slots, introduced in Postgres 9.4, enable a master server to keep track of the state of replicas and retain WAL segments they might need.

Nickolay Ihalainen

Managing High Availability in Postgres — The first in a three part series on how to manage high availability using streaming replication via open source tools for automatic failover, monitoring and replication.

Madan Kumar K

Why Citus Data Is Donating 1% Equity to the PostgreSQL Non-Profits — The Citus Data co-founders share why they’re giving a piece of their future success to the Postgres community.

CITUS DATA sponsor

▶  Postgres and Kubernetes: DBaaS Without Vendor Lock-In — A 30 minute talk on using Kubernetes to create your own Postgres-powered database as a service.

Oleksii Kliukin

🗓 Events

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 2018Decemeber 10-12 (Tokyo, Japan) The largest PostgreSQL event in Asia.

FOSDEM PGDay 2019 February 1, 2019 (Brussels, Belgium) An extension to the regular PostgreSQL activities at FOSDEM.