--- title: "This Week's PostgreSQL News (#191)" publication: "Postgres Weekly" issue: 191 published_at: "2017-01-25" canonical_url: "https://postgresweekly.com/issues/191" --- Postgres Weekly 191 . [Read this on the Web](http://postgresweekly.com/issues/191) [Postgres Weekly](http://postgresweekly.com) Issue 191 — January 25, 2017 [PostgreSQL Exercises](https://pgexercises.com/?utm_source=postgresweekly&utm_medium=email)If you’re looking for a way to practice your SQL skills, PG Exercises offers some good example data and exercises to hone your skills. Alisdair Owens#tools [Logical Replication Committed to Postgres](https://github.com/postgres/postgres/commit/665d1fad99e7b11678b0d5fa24d2898424243cd6?utm_source=postgresweekly&utm_medium=email)Postgres 10 is starting to take shape and one of the most exciting features for it has landed: logical replication directly in core. PostgreSQL on GitHub#news [The Internals of PostgreSQL](http://www.interdb.jp/pg/index.html?utm_source=postgresweekly&utm_medium=email)Suzuki Hironobu covers the internals of PostgreSQL for database administrators and system developers in this helpful translation of [his 2012 Japanese-language book](https://www.amazon.com/Posutogure-esukyueru-zenkino-baiburu-posutoguresukyueru/dp/4774153923). Suzuki Hironobu [[Free Tool\] Network Analyzer for PostgreSQL](https://www.vividcortex.com/resources/network-analyzer-for-postgresql?utm_campaign=Postgres%20Weekly&utm_source=ppc)VividCortex’s network traffic analyzer tool for PostgreSQL is an easy-to-use way to gain insight into your server’s activity. Built for PostgreSQL servers running on Linux operating systems, it is a non-intrusive, safe way to understand your query workload. VividCortex#sponsored[![\](https://copm.s3.amazonaws.com/2cbeee61.png)](https://www.vividcortex.com/resources/network-analyzer-for-postgresql?utm_campaign=Postgres%20Weekly&utm_source=ppc) [PostgresOpen 2017 (Sep 6-8 in Silicon Valley)](https://2017.postgresopen.org/?utm_source=postgresweekly&utm_medium=email)This year, PostgresOpen has combined with PGConf SV. Not many details yet but you can sign up to stay informed. postgresopen.​org#news [PostgreSQL Compatibility for Amazon Aurora Now Available (in Preview)](https://twitter.com/i/web/status/824036572269940736?utm_source=postgresweekly&utm_medium=email) Amazon Web Services#news [Building a Blog Engine API with GraphQL, Go and Postgres](http://alexandrutopliceanu.ro/post/graphql-with-go-and-postgresql/?utm_source=postgresweekly&utm_medium=email)A look at the concerns around designing a simple blogging API, considering both GraphQL and traditional REST-based approaches. Alexandru Topliceanu#tutorial [Creating SSL Certificates for Postgres](http://momjian.us/main/blogs/pgblog/2017.html?utm_source=postgresweekly&utm_medium=email#January_12_2017)Postgres has the ability to ensure you’re connecting in a secure fashion. To do this you need to provide a certificate; here’s the few different ways you can create them if you need to. Bruce Momjian#tutorial [Performance Issues with 'OR'ed Conditions](http://blog.rhodiumtoad.org.uk/2017/01/22/performance-issues-with-ored-conditions/?utm_source=postgresweekly&utm_medium=email)OR can often be a problem if you want performant queries, this deep dive shows when it makes sense and when it doesn’t as well as how to work around it when you still need it. The Rhodium Toad#tutorial [Metrics Maven: calculating a weighted average in PostgreSQL](https://compose.com/articles/metrics-maven-calculating-a-weighted-average-in-postgresql/)In this episode of our Metrics Maven series, we show how to calculate a weighted average in PostgreSQL. Compose#tutorial#sponsored [Managing Concurrency in Postgres [Podcast\]](http://threedevsandamaybe.com/managing-concurrency-in-postgres-with-bruce-momjian/?utm_source=postgresweekly&utm_medium=email)An exploration of how Postgres manages concurrency with guest Bruce Momjian. _1hr 21 minutes_. Three Devs and a Maybe [Running Production PostgreSQL Systems on ARM Architecture](http://www.cybertec.at/running-production-postgresql-systems-on-arm-architecture/?utm_source=postgresweekly&utm_medium=email)A whitepaper exploring whether running Postgres on ARM is a viable option for your next project. Kaarel Moppel#opinion [pg_zlog: Table Replication for Postgres Nodes with Ceph and ZLog](https://github.com/noahdesu/pg_zlog?utm_source=postgresweekly&utm_medium=email)Replication is implemented by logging table mutations to a consistent shared-log called ZLog that runs on the [Ceph](https://github.com/ceph/ceph) distributed storage system. Noah Watkins#tools [PostgREST: A REST API for Any Postgres Database](https://github.com/begriffs/postgrest?utm_source=postgresweekly&utm_medium=email)Want an out of the box REST API on top of your Postgres database? [Version 0.4.0](https://github.com/begriffs/postgrest/releases/tag/v0.4.0.0) of this long-standing project is now out with more new features. Joe Nelson#code Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/191) [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