---
title: "#218: Implementing State Machines in Postgres"
publication: "Postgres Weekly"
issue: 218
published_at: "2017-08-02"
canonical_url: "https://postgresweekly.com/issues/218"
---

Postgres Weekly 218   . 

[Read this on the Web](http://postgresweekly.com/issues/218) 

[Postgres Weekly](http://postgresweekly.com) Issue 218 — August 2, 2017     

[Implementing State Machines in Postgres](http://felixge.de/2017/07/27/implementing-state-machines-in-postgresql.html?utm_source=postgresweekly&utm_medium=email)A practical look at creating a FSM in Postgres using a transition function, a user-defined aggregate function and a table to keep track of events. Felix Geisendörfer [A Practical Guide to SQL Transaction Isolation](https://begriffs.com/posts/2017-08-01-practical-guide-sql-isolation.html?utm_source=postgresweekly&utm_medium=email)A detailed post on how transaction isolation works, particularly in Postgres. A good read if you just rely on the defaults. Joe Nelson [Scaling Out (Postgre)SQL](https://www.dotconferences.com/2017/04/marco-slot-scaling-out-postgresql?utm_source=postgresweekly&utm_medium=email)An in-depth talk on scaling via distributing query computation tasks across many servers. _(Note: To watch the video, click the yellow play button.)_ Marco Slot#video [2ndQuadrant PostgreSQL Conference - November 6-9, 2017](http://www.2qpgconf.com)2Q PGConf is dedicated to exchanging & increasing knowledge about PostgreSQL. Join us for this unique opportunity taking place in NYC & Chicago to learn more about recent achievements and exciting future developments in PostgreSQL from world-class experts. 2ndQuadrant PostgreSQL Events#sponsored[![\](https://copm.s3.amazonaws.com/b2ef3d1e.jpg)](http://www.2qpgconf.com) [A 'Call for Quotes' for Postgres 10's Release Notes](https://www.postgresql.org/message-id/E1D3EFCE-D0E3-48AE-A163-ED7D195C446C%40postgresql.org?utm_source=postgresweekly&utm_medium=email)The Postgres team are looking for quotes from Postgres users about new features in the upcoming release. Jonathan S.​ Katz#news [PostGIS 2.3.3 Is Now Available with BigSQL](https://www.openscg.com/2017/07/postgis-2-3-3-is-now-available/?utm_source=postgresweekly&utm_medium=email)A patch release with a focus on fixing bugs and breakages. Holly Orr#news [Calculating Response Times with Window Functions and CTEs](https://medium.com/@chamini2/average-response-time-with-postgres-window-functions-and-ctes-a19adb7ed4f7?utm_source=postgresweekly&utm_medium=email) Matteo Ferrando [Database Table Types with Citus and Postgres](https://www.citusdata.com/blog/2017/07/27/database-table-types-with-citus-and-postgres/?utm_source=postgresweekly&utm_medium=email)Citus, which extends Postgres to make sharding simple, introduces a few new types of tables in Postgres. Here’s a tour of the things you need to think about. citusdata [Work Smarter with SelectStar](https://selectstar.io/blog/3-strategies-improve-postgresql-performance-replication/)See how SelectStar can expertly monitor replication in your Postgres database. Start your free trial today. SelectStar#sponsored [Analyzing a Billion Taxi Rides with BrytlytDB and 2 GPU-Powered EC2 Instances](http://tech.marksblogg.com/billion-nyc-taxi-rides-aws-ec2-p2-16xlarge-brytlytdb.html?utm_source=postgresweekly&utm_medium=email)[BrytlytDB](http://www.brytlyt.com/) is an in-GPU-memory database built on top of Postgres. Mark Litwintschik [Postgres Natural Joins Squash Unneeded Columns](http://til.hashrocket.com/posts/tyz0whhvc9-postgres-natural-joins-squash-unneeded-columns?utm_source=postgresweekly&utm_medium=email)When it comes to databases there are a number of types of joins that exist. Natural joins are a less known set that can help as highlighted here. Hashrocket TIL    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/218) [See our archives](http://postgresweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*)  [Stop getting this newsletter](*|UNSUB|*)  

Published by [Cooperpress](https://cooperpress.com/)
Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK