#230: Postgres 10 vs. TimescaleDB for Time-Series Data

.

Read this on the Web

Postgres Weekly Issue 230 — October 25, 2017

Postgres Domain Integrity In Depth 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 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 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  PostgreSQL Index Suggestion With POWA POWA is a Postgres ‘workload analyzer’ for monitoring and tuning your Postgres setup. Mouhamadou Diaw 2Q PGConf 2017 (November 6-9, NYC and Chicago) 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 A quick visual overview of Postgres’ MVCC model. Diana Hsieh Doing Battle With a Phantom WAL Segment An interesting tale of a Postgres bug that was fixed in August. Keiko Oda Merging RethinkDB and Postgres with GraphQL This company couldn’t migrate entirely to Postgres, so ran it in parallel with RethinkDB. Collaborizm The Best Bits of Postgres 10 for Developers A brief overview of some favourite developer-focused features in Postgres 10. Kaarel Moppel   #opinion  Practical Query Optimization for MySQL and PostgreSQL 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 Works with SQLite, MySQL and Postgres. Paul Fitzpatrick   #tools  pg_blkchain: A Blockchain Extension for Postgres Gregory Trubetskoy   #code  Postgres Weekly is curated by Craig Kerstiens Read this issue on the Web See our archives Change your email address Stop getting this newsletter Published by Cooperpress Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK