---
title: "#230: Postgres 10 vs. TimescaleDB for Time-Series Data"
publication: "Postgres Weekly"
issue: 230
published_at: "2017-10-25"
canonical_url: "https://postgresweekly.com/issues/230"
---

Postgres Weekly 230   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 230 — October 25, 2017     

[Postgres Domain Integrity In Depth](https://begriffs.com/posts/2017-10-21-sql-domain-integrity.html?utm_source=postgresweekly&utm_medium=email)An extensive write up about ways to keep your data ‘squeaky clean’ by way of integrity constraints. There’s a _lot_ to learn from here. Joe Nelson [Postgres 10 vs. TimescaleDB for Time-Series Data](https://blog.timescale.com/time-series-data-postgresql-10-vs-timescaledb-816ee808bac5?utm_source=postgresweekly&utm_medium=email)PostgreSQL 10 promises an easier partitioning mechanism to help scale for big data. But how does that compare to TimescaleDB for time-series workloads? Erik Nordström#opinion [Develop Applications That Wow](http://inter.viewcentral.com/reg/enterprisedb/PostgresDeveloperTraining)Train to build custom apps fast and effectively. Access comprehensive training for app development with Postgres from the industry’s most credible source for Postgres Developer Training, EnterpriseDB. Explore EDB’s developer courses. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/3c6c59f2.png)](http://inter.viewcentral.com/reg/enterprisedb/PostgresDeveloperTraining) [PostgreSQL Index Suggestion With POWA](https://blog.dbi-services.com/postgresql-index-suggestion-with-powa/?utm_source=postgresweekly&utm_medium=email)[POWA](http://dalibo.github.io/powa/) is a Postgres ‘workload analyzer’ for monitoring and tuning your Postgres setup. Mouhamadou Diaw [2Q PGConf 2017 (November 6-9, NYC and Chicago)](http://www.2qpgconf.com/?utm_source=postgresweekly&utm_medium=email)Training and talks in New York on Nov 6 and 7, with another day of talks in Chicago on Nov 9. Use code `Cooper_40` for a 40% discount on both general admission and/or training. 2Q PGconf 2017#news [Learning with Diagrams: Handling Contention with Postgres](https://medium.com/@dianahsieh323/learning-w-diagrams-handling-contention-with-postgresql-109798b8ad54?utm_source=postgresweekly&utm_medium=email)A quick visual overview of Postgres’ MVCC model. Diana Hsieh [Doing Battle With a Phantom WAL Segment](https://blog.keikooda.net/2017/10/18/battle-with-a-phantom-wal-segment/?utm_source=postgresweekly&utm_medium=email)An interesting tale of a Postgres bug that was fixed in August. Keiko Oda [Merging RethinkDB and Postgres with GraphQL](https://blog.collaborizm.com/merging-rethinkdb-and-postgres-with-graphql-b8801f69c8ea?utm_source=postgresweekly&utm_medium=email)This company couldn’t migrate entirely to Postgres, so ran it in parallel with RethinkDB. Collaborizm [The Best Bits of Postgres 10 for Developers](http://www.cybertec.at/best-of-postgresql-10-for-the-developer/?utm_source=postgresweekly&utm_medium=email)A brief overview of some favourite developer-focused features in Postgres 10. Kaarel Moppel#opinion [Practical Query Optimization for MySQL and PostgreSQL](https://www.vividcortex.com/resources/practical-query-optimization?utm_campaign=Postgres%20Weekly&utm_source=ppc&utm_medium=Practical%20Query)In this book, you’ll learn how to find, evaluate, and improve the queries running on your database servers. VividCortex#sponsored [visql: Edit 'Slices' of SQL Databases in Vi/Vim](https://github.com/paulfitz/visql?utm_source=postgresweekly&utm_medium=email)Works with SQLite, MySQL and Postgres. Paul Fitzpatrick#tools [pg_blkchain: A Blockchain Extension for Postgres](https://github.com/blkchain/pg_blkchain?utm_source=postgresweekly&utm_medium=email) Gregory Trubetskoy#code    

Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/230) [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