---
title: "Postgres 10.4 released, and having fun with recursive CTEs"
publication: "Postgres Weekly"
issue: 256
published_at: "2018-05-16"
canonical_url: "https://postgresweekly.com/issues/256"
---

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

#256 — May 16, 2018 

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

Postgres Weekly  

[PostgreSQL 10.4, 9.6.9, 9.5.13, 9.4.18, and 9.3.23 Released](https://www.postgresql.org/about/news/1851/) — This release fixes one security issue in all supported versions, as well as [numerous bugs](https://www.postgresql.org/docs/10/static/release-10-4.html) reported over the last few months. 

PostgreSQL Global Development Group   

[Fun with SQL: Recursive CTEs in Postgres](https://www.citusdata.com/blog/2018/05/15/fun-with-sql-recursive-ctes/) — A quick exploration of _recursive_ CTEs (Common Table Expressions) which allow _themselves_ to be called until some condition is met. 

Craig Kerstiens   [![\](https://copm.s3.amazonaws.com/63db63b4.png)](https://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-primary) 

[Linux Cloud Hosting Starting at 1GB of RAM for $5/mo](https://welcome.linode.com/postgres-weekly/?utm_source=cooperpress&utm_medium=sponsored&utm_campaign=postgres-weekly-primary) — 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](https://severalnines.com/blog/overview-serial-pseudo-datatype-postgresql) — 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](https://blog.timescale.com/how-to-store-time-series-data-mongodb-vs-timescaledb-postgresql-a73939734016) — TimescaleDB is [a Postgres extension](https://github.com/timescale/timescaledb) 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 Linux](https://www.cybertec-postgresql.com/en/linux-cgroups-for-postgresql/) — _Control 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\]](http://s3.cleverelephant.ca/2018-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](https://severalnines.com/product/clustercontrol/for_postgresql?utm_campaign=Crisis_Campaign_MAY_2018&utm_content=pg_weekly&utm_medium=Paid_Search&utm_source=banner) 

Severalnines sponsor   

[From Nothing to REST API with PostgREST](https://gist.github.com/michelp/efc882ce86bd60d50dcf5f11442a2aaf) — A minimal example of getting a PostgREST API running from scratch for testing purposes. 

Michel Pelletier  

Events  

[PostgresOpen 2018: Call for Papers](https://www.postgresql.org/about/news/1852/) — The [event](https://2018.postgresopen.org/) takes place early September in San Francisco. Talk submissions will be accepted up until June 12. 

PostgresOpen   

[Postgres Vision 2018](http://postgresvision.com/) — **June 5-6 (Boston, USA)** Postgres in the Cloud - Front and center at Postgres Vision 2018.    

[PGDay.IT 2018](https://2018.pgday.it/it/) — **June 28 - 29 (Pacengo di Lazise, Italy)** The Italian conference dedicated to PostgreSQL.    

[PGConf UK 2018](https://www.postgresql.org/about/event/2224/) — **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.          

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