#256 — May 16, 2018

Read on the Web

Postgres Weekly

PostgreSQL 10.4, 9.6.9, 9.5.13, 9.4.18, and 9.3.23 Released — This release fixes one security issue in all supported versions, as well as numerous bugs reported over the last few months.

PostgreSQL Global Development Group

Fun with SQL: Recursive CTEs in Postgres — A quick exploration of recursive CTEs (Common Table Expressions) which allow themselves to be called until some condition is met.

Craig Kerstiens

Linux Cloud Hosting Starting at 1GB of RAM for $5/mo — Get a Linode server up and running in seconds. Simply choose your plan, distro and location and you’re ready to deploy your server. Get $20 credit on a new account.

Linode Cloud Hosting sponsor

An Overview of the 'serial' Pseudo-Datatype — An introduction to the special implementation of serial data types typically used for the creation of synthetic primary keys.

Berend Tober

TimescaleDB vs MongoDB for Storing Time-Series Data — TimescaleDB is a Postgres extension focused on time-series data, so it may come as no surprise that it’s faster at the task.

Rob Kiefer

Using 'cgroups' to Limit Postgres Resource Usage on LinuxControl groups are a Linux feature that allow processes to be organized into hierarchical groups whose usage of various types of resources can be limited and monitored.

Laurenz Albe

PostGIS for Managers [PDF] — Note-heavy slides presenting an introduction to PostGIS, how its features compare to Oracle’s, and how it can integrate with other systems.

Paul Ramsey slidedeck

Unified Management & Automation for PostgreSQL

Severalnines sponsor

From Nothing to REST API with PostgREST — A minimal example of getting a PostgREST API running from scratch for testing purposes.

Michel Pelletier

Events

PostgresOpen 2018: Call for Papers — The event takes place early September in San Francisco. Talk submissions will be accepted up until June 12.

PostgresOpen

Postgres Vision 2018 June 5-6 (Boston, USA) Postgres in the Cloud - Front and center at Postgres Vision 2018.

PGDay.IT 2018 June 28 - 29 (Pacengo di Lazise, Italy) The Italian conference dedicated to PostgreSQL.

PGConf UK 2018 July 2- 3 (London, UK) Will be held on July 3, with an optional training day on July 2, and will be hosted at 30 Euston Square.