--- title: "New bug fix Postgres releases, and Envoy gets Postgres monitoring support" publication: "Postgres Weekly" issue: 369 published_at: "2020-08-19" canonical_url: "https://postgresweekly.com/issues/369" --- Plus more news, tutorials, and tips from the Postgres world this week. #369 — August 19, 2020 [Web Version](https://postgresweekly.com/issues/369) Postgres Weekly [![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/frkwxajs9vvoj2iol3af.jpg)](https://github.com/graphile/postgraphile) [Postgraphile: Quickly Get a GraphQL API for Your Postgres Database](https://github.com/graphile/postgraphile) — Work on v5 of this popular Node.js tool is underway, but meanwhile we get a 4.8 release which supports ‘enum tables’ and all of Postgres’s built-in geometric types. If you want to offer a Postgres database up over a GraphQL-based API, it’s worth checking out. Graphile [Postgres 12.4, 11.9, 10.14, 9.6.19, 9.5.23, and 13 Beta 3 Released](https://www.postgresql.org/about/news/2060/) — A flurry of Postgres releases to fix a variety of bugs but, more importantly, two security vulnerabilities (in versions 9.5-12 only). We’re also reminded that Postgres 9.5 will stop receiving fixes after February 2021. PostgreSQL Global Development Group [![\](https://copm.s3.amazonaws.com/68061b63.png)](https://www.datadoghq.com/dg/monitor/postgresql-benefits/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyBenefitsP) [Real-Time Postgres Performance Monitoring](https://www.datadoghq.com/dg/monitor/postgresql-benefits/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyBenefitsP) — 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 [Building a Recommendation Engine Inside Postgres with Python and Pandas](https://info.crunchydata.com/blog/recommendation_engine_in_postgres_with_pandas_and_python) — Learn how you can leverage Python and Pandas from directly inside Postgres to build your own recommendation engine. Craig Kerstiens [An Introduction to Recursive Queries](https://www.cybertec-postgresql.com/en/recursive-queries-postgresql/) — Recursive queries (built using `WITH`) let you do interesting things with SQL and aren’t _too_ difficult to understand, particularly with the simple practical examples given here. Laurenz Albe [SQLite 3.33.0 Released (With a Postgres-Inspired Feature)](http://www.sqlite.org/releaselog/3_33_0.html) — We don't often cover SQLite in this newsletter, but when the world’s most heavily used database engine gains support for [UPDATE FROM](https://www.sqlite.org/lang_update.html#upfrom) and aims to be compatible with Postgres's implementation, why not? 😄 SQLite Team [Timescale Cloud Extends to 76 Regions Across 3 Clouds](https://blog.timescale.com/blog/fully-managed-time-series-data-service-now-available-in-aws-azure-gcp-75-regions-compare-vs-influxdb-timestream/) — TimescaleDB essentially extends Postgres with significant time-series data functionality and _Timescale Cloud_ is the creator’s commercial ‘TimescaleDB in the cloud’ service. Timescale [Envoy 1.15 Introduces a New Postgres Extension with Monitoring Support](https://www.cncf.io/blog/2020/08/13/envoy-1-15-introduces-a-new-postgres-extension-with-monitoring-support/) — [Envoy](https://www.envoyproxy.io/) is a popular service proxy for cloud applications, and it can now ‘speak’ Postgres’ wire protocol! This post digs into why this plugin was developed, what functionality it currently implements, and what the roadmap looks like for future releases. CNCF [Running Multiple PgBouncer Instances with `systemd`](https://www.2ndquadrant.com/en/blog/running-multiple-pgbouncer-instances-with-systemd/) — [PgBouncer](https://www.pgbouncer.org/) is a connection pooler that runs as a single process, but with a little work you can run multiple instances for different virtual hosts. Peter Eisentraut [A Look at Keyset Pagination](https://momjian.us/main/blogs/pgblog/2020.html#August_12_2020) — Last week, Bruce covered [pagination approaches in general](https://momjian.us/main/blogs/pgblog/2020.html#August_10_2020) and is now focusing on one technique, using `LIMIT` and `OFFSET` alongside `WHERE`. He’s also dug into [how it works in practice](https://momjian.us/main/blogs/pgblog/2020.html#August_17_2020) while items are being inserted or deleted. Bruce Momjian [CockroachDB: Scalable, Distributed PostgreSQL](https://www.cockroachlabs.com/db/postgres/?utm_campaign=cooperpress-2020-Q3&utm_source=postgres-weekly&utm_medium=newsletter&utm_content=distributed-postgresql) — Never shard a Postgres instance again. Meet CockroachDB, the Distributed SQL database that’s naturally resilient and provides out-of-the-box scalability. Cockroach Labs sponsor [Iterators in Postgres with Lateral Joins](https://info.crunchydata.com/blog/iterators-in-postgresql-with-lateral-joins) — _“When the keyword `LATERAL` is added to your join the output will now apply the right hand part of the join to every record in the left part of the join.”_ Steve Pousty [How We Used Postgres Extended Statistics to Achieve a 3000x Speedup](https://t.co/xPtg3Szr7d?amp=1) — Big numbers like that always make me put my cynical eyeglasses on, but in this case it’s a neat technical tale of encouraging Postgres to do the right thing. Jared Rulison [PostGIS 3.0.2, 2.5.5, and 2.4.9 Released](http://postgis.net/2020/08/15/postgis-patches/) — Minor bug fix and performance enhancement releases for the popular geospatial extension. PostGIS Developers Curated by [Cooperpress](https://cooperpress.com/), [Peter Cooper](https://twitter.com/peterc), 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