#263 — July 4, 2018

Read on the Web

Postgres Weekly

PostgreSQL 11 Beta 2 Released — In related news, the HEAD of Postgres’s git repository is now for Postgres 12, so there will be no further new features for PG 11.

PostgreSQL Global Development Group

PostgreSQL Tuning: Key Things to Drive Performance — Several high-level tips for getting the most performance out of your Postgres setup.

Viorel Tabara

Because Your Data Is Your Business — PGX's open source experts provide the database and application skills necessary to solve database problems, accelerate existing applications, refactor infrastructure, and develop new applications.

PostgreSQL Experts, Inc. sponsor

Postgres Concurrency: Isolation and Locking — A brief primer on Postgres’s isolation and locking properties and behaviors.

Dimitri Fontaine

pgquarrel 0.4: The Postgres Schema Comparison Tool — Given two database connections, it’ll output data representing the difference between schemas. The main use case is to deploy database changes into testing, staging or production environments.

Euler Taveira

Rules vs Trigger Performance When Logging Bulk UpdatesRules let you define an alternate action to be performed on table inserts, updates, or deletions, and can work as an alternative to triggers in some situations.

Laurenz Albe

Options for Scaling From 1 to 100,000 Tenants — If you’re building a multi-tenant SaaS app and you plan for your business to grow, you’re going to face the question of how to scale your database. This post covers the options, from proprietary to open source, relational to NoSQL, scale up to scale out.

Craig Kerstiens

The Diagnostic Tale of an Unexpected Slowdown — Digging into a performance issue with a Postgres database and how it was resolved.

Julien Rouhaud

Take Control of Your Postgres Databases in the Cloud

EDB Managed DBaaS Service sponsor

PostGIS 2.5 Beta 1 Released — The spatial and geographic object system for Postgres takes another step towards a final release - Postgres 11 beta 2 is recommended here.

PostGIS Developers

Events

PGDay.Amsterdam July 12 (Amsterdam, Netherlands) Meet & learn from other PostgreSQL users, developers and anyone who’s interested in the most advanced open source database.

PostgresOpen 2018 September 5-7 (San Francisco, CA) PostgresOpen is happening again this year in San Francisco and the talk list is now live. Here’s a breakdown of just a few of the interesting talks.

Postgresql Conference Europe October 23-26 2018 (Lisbon, Portugal) The 10th Annual PostgreSQL Conference Europe which will be held at the Lisbon Marriott Hotel.