#277 — October 10, 2018

Read on the Web

Postgres Weekly

PostGraphile v4 Released: A GraphQL API for Your Database — Execute one command (or mount one Node.js middleware) and get a high-performance GraphQL API for your database.

Benjie Gillam

The Versatile INSERT — A look at ‘some of the more interesting things’ you can do with INSERT in Postgres, beyond just adding a single row to a table, of course.


Real-Time Postgres Performance Monitoring — Collect out-of-the-box and custom PostgreSQL metrics and correlate them with data from your distributed infrastructure, applications, and logs. Gain real-time performance insights and set intelligent alerts with Datadog. Start a free trial.

Datadog sponsor

Dynamic Monitoring of Postgres Instances using pg_toppg_top is an open source tool for monitoring Postgres processes (a la Unix top).

Brian Fehrle

Select Star SQL: An Interactive SQL Tutorial — Want to get a bit better at SQL? This interactive online guide will give you some practical experience and is oriented, intriguingly, around querying a dataset of death row inmates.

Zi Chong Kao

Working with Unions in Postgres — A primer with examples on using the UNION and UNION ALL operators when you need to unify results from multiple tables or queries.

Gary Sahota

An Example of Moving a Tablespace — Tablespaces let you define where various database objects are stored on the underlying file system - but what if you want to move one?

Bruce Momjian

Detailed Logging for Enterprise-Grade Postgres — A look at some of the config parameters you can tweak to get more detailed logs.

Fernando Laudares Camargos

How to Manage Prometheus High-Availability with Postgres and TimescaleDBPrometheus is a popular open source monitoring system.

Niksa Jakovljevic

An Express.js, Sequelize, and Postgres Association Tutorial — If you want to work with Postgres from a Node.js webapp, this could be a handy primer.

Didin Jamaludin

Improving Sort Performance — Shows how Postgres sorts can be tuned.

Hans-Jürgen Schönig

Comparing EDB Postgres Platform to Self-Supported PostgreSQL — Watch the video.

EnterpriseDB sponsor

pspg: An Alternative Pager for Postgres's psql Client — Replaces less and brings in support for tabular data.

Pavel Stehule

tic-tac-toe.sql: Tic Tac Toe Implemented in SQL

Mariusz Krynski

🗓 Events

2Q PGConf 2018 December 4-5 (Chicago) A conference dedicated to exchanging PostgreSQL knowledge.

PGCONF.ASIA 2018 Decemeber 10-12 (Tokyo, Japan) PGConf.ASIA 2018 is an international conference for PostgreSQL. Come and join this one of the largest PostgreSQL conference held in Asia.

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