---
title: "How Postgres's SQL Dialect Stays Ahead of Its Competitors"
publication: "Postgres Weekly"
issue: 266
published_at: "2018-07-25"
canonical_url: "https://postgresweekly.com/issues/266"
---

The latest Postgres news, articles, tools, and projects.       

#266 — July 25, 2018 

[Read on the Web](https://postgresweekly.com/issues/266)   

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/ru1li3igpoii0e9kqvs0.jpg)](https://modern-sql.com/slides/PG-stays-ahead-20180718.pdf)  

PDF: [How Postgres's SQL Dialect Stays Ahead of Its Competitors](https://modern-sql.com/slides/PG-stays-ahead-20180718.pdf) — Yes, it’s a slide deck, but it’s a Markus Winand slide deck and full of examples. I found a possibly unofficial [video of the associated talk](https://www.youtube.com/watch?v=HeXNr13iBzw#t=18m20s) if you’re curious. 

Markus Winand   

[More of My Favorite PostgreSQL Queries - and Why They Matter](https://severalnines.com/blog/more-my-favorite-postgresql-queries-and-why-they-also-matter) — A follow up to April’s popular post [_My favourite PostgreSQL queries and why they matter_](https://severalnines.com/blog/my-favorite-postgresql-queries-and-why-they-matter). This time the focus is on a multi-row UPDATE with a single CASE expression, with comparisons between that particular query and one involving multiple single UPDATE statements, plus a look at using cursors. 

Joshua Otwell   [![\](https://copm.s3.amazonaws.com/0e2a68ac.jpg)](https://www.influxdata.com/blog/monitoring-your-postgresql-database-with-telegraf-and-influxdb/) 

[Monitoring Your PostgreSQL Database with Telegraf and InfluxDB](https://www.influxdata.com/blog/monitoring-your-postgresql-database-with-telegraf-and-influxdb/) — Learn how to use [Telegraf](https://www.influxdata.com/time-series-platform/telegraf/) (the agent for collecting and reporting metrics & events) and [InfluxDB](https://www.influxdata.com/time-series-platform/influxdb/) (the fastest growing open source TSDB) to monitor your PostgreSQL database. 

InfluxData sponsor   

[Dox: A Pure Postgres Document Database API](https://rob.conery.io/2018/07/05/a-pure-postgresql-document-database-api/) — A set of functions written in PLPGSQL that help you use Postgres as a ‘schemaless’ document database with the least hassle. [GitHub repo.](https://github.com/robconery/dox/) 

Rob Conery   

[Troubleshooting Postgres Streaming Replication Synchronization](https://info.crunchydata.com/blog/wheres-my-replica-troubleshooting-streaming-replication-synchronization-in-postgresql) — A practical guide to detecting if your replicas are out-of-sync and how to restore them efficiently without a base backup. 

Jonathan S. Katz   

[Troubleshooting Daily Write Spikes on RDS](https://medium.com/cermati-tech/troubleshooting-daily-write-spikes-on-cermatis-postgresql-rds-9016d7a0c2e4) — An engineer at an Indonesian fintech company shares the story of tracing down the source of an unusual IO spike on their AWS RDS-based Postgres database. 

Edwin Tunggawan   

[Scaling IoT Time Series Data with Postgres-BDR](https://blog.2ndquadrant.com/scaling-iot-time-series-data-postgres-bdr/) — Have you ever thought about using Postgres for IoT-type workloads? It’s possible. There’s also [a second post](https://blog.2ndquadrant.com/postgresql-time-based-partitioning-iot-pgpartman/) looking at [time-based partitioning for IoT data using pg_partman.](https://blog.2ndquadrant.com/postgresql-time-based-partitioning-iot-pgpartman/) 

Muhammad Haroon   

[Using search_path and Views to Hide Columns for Reporting with Postgres](https://www.citusdata.com/blog/2018/07/03/masking-columns-in-postgresql/) — Tips on using Postgres schemas and views to provide access to data while keeping Personally Identifiable Information (PII) safe and hidden. From the distributed database team at Citus Data. 

citusdata   

[Using LISTEN/NOTIFY to Maintain an External In-Memory Cache](https://tapoueh.org/blog/2018/07/postgresql-listen/notify/) — How to maintain an external cache in a Golang-powered service, using Postgres’s `LISTEN` and `NOTIFY` features. 

Dimitri Fontaine   

[Real-Time Postgres Performance Monitoring. Try Datadog Free](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyB) 

Datadog sponsor   

▶[Build Modern Applications using Azure Database for PostgreSQL](https://www.youtube.com/watch?v=O4TqUvajbU8) 

Microsoft Build  

Events  

[PGConf Brazil 2018](http://www.pgconf.com.br/2018_en/) — **August 3 - 4 (São Paulo, Brazil)** Two day conference with talks, tutorials, Couch Clinic, FishBowl and Lightning Talks.    

[PostgresOpen SV 2018](https://2018.postgresopen.org/) — **September 5-7 (San Francisco, CA)** Two days packed with tutorials and presentations about PostgreSQL.    

[PostgreSQL Day 2018](https://pdx.postgresql.us/pdxpgday2018) — **September 10 (Portland, Oregon)** A day of presentations about PostgreSQL.          

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom