--- title: "#228: PostgreSQL 10 Released" publication: "Postgres Weekly" issue: 228 published_at: "2017-10-11" canonical_url: "https://postgresweekly.com/issues/228" --- Postgres Weekly 228 . [Read this on the Web](http://postgresweekly.com/issues/228) [Postgres Weekly](http://postgresweekly.com) Issue 228 — October 11, 2017 [PostgreSQL 10 Released](https://www.postgresql.org/about/news/1786/?utm_source=postgresweekly&utm_medium=email)Includes enhancements to effectively implement the divide and conquer strategy, including native logical replication, declarative table partitioning, and improved query parallelism. [More on what’s new here](https://wiki.postgresql.org/wiki/New_in_postgres_10). Postgres.​org#news [Scaling GitLab's Postgres Database](https://about.gitlab.com/2017/10/02/scaling-the-gitlab-database/?utm_source=postgresweekly&utm_medium=email)GitLab is a popular git repository host, and this is an in-depth look at the challenges faced scaling their Postgres setup. Yorick Peterse [State of Production Database Performance 2017](https://www.vividcortex.com/resources/state-of-production-database-performance-2017?utm_campaign=Postgres%20Weekly&utm_source=ppc&utm_medium=State%20of%20Production)In this report we explore and definitively answer whether MySQL or PostgreSQL is truly faster than the other. VividCortex#sponsored[![\](https://copm.s3.amazonaws.com/1a900f19.png)](https://www.vividcortex.com/resources/state-of-production-database-performance-2017?utm_campaign=Postgres%20Weekly&utm_source=ppc&utm_medium=State%20of%20Production) [38 Videos from PostgresOpen Silicon Valley 2017](https://www.youtube.com/playlist?list=PLN8NEqxwuywQgN4srHe7ccgOELhZsO4yM&utm_source=postgresweekly&utm_medium=email#pgopen2017)A rich variety of talks from the recent Postgres conference, including a guide to [upgrading Postgres](https://www.youtube.com/watch?v=CzhVkdnbQBU&index=10&list=PLN8NEqxwuywQgN4srHe7ccgOELhZsO4yM), [tuning Postgres for high write workloads](https://www.youtube.com/watch?v=xrMbzHdPLKM&index=13&list=PLN8NEqxwuywQgN4srHe7ccgOELhZsO4yM), and [securing Postgres.](https://www.youtube.com/watch?v=6zdk-P2t2xc&index=18&list=PLN8NEqxwuywQgN4srHe7ccgOELhZsO4yM) YouTube#video [A Look at Transition Relations](http://blog.postgresql-consulting.com/2017/10/postgresqls-transition-relations.html?utm_source=postgresweekly&utm_medium=email)Transition relations are row sets that include all of the rows inserted, deleted, or modified by the current SQL statement, and are used in triggers to see a view of what the statement did. Alexey Lesovsky [Whats New in Postgres 10: Monitoring Improvements](https://pganalyze.com/blog/whats-new-in-postgres-10-monitoring-improvements.html?utm_source=postgresweekly&utm_medium=email)Postgres now has a monitoring role that can be used for external monitoring tools. There’s also now an easy way to check B-tree indexes for corruption. Lukas Fittl [pgAdmin 4 v2.0 Released](https://www.pgadmin.org/?utm_source=postgresweekly&utm_medium=email)The popular open source management/admin tool now supports Postgres 10 and is faster. PostgreSQL#tools [Implementing Faceted Search with Django and PostgreSQL](https://simonwillison.net/2017/Oct/5/django-postgresql-faceted-search/?utm_source=postgresweekly&utm_medium=email)Using the PostgreSQL search functionality that was introduced in Django 1.10 to implement full-text search. Simon Willison [How Postgres Could Index Itself](https://www.youtube.com/watch?v=Mni_1yTaNbE&utm_source=postgresweekly&utm_medium=email)Postgres keeps a lot of details about its data and usage patterns under the covers. In this talk, the author of pghero looks at how Postgres could start to self index with such data. Andrew Kane#video [Real-Time Analytics using Postgres](https://engineering.semantics3.com/real-time-analytics-using-postgres-702e3796f71c?utm_source=postgresweekly&utm_medium=email)Dashboards are great for your users, except when they’re slow. This post walks through an approach to rollup your data to provide more performant dashboards across larger data. Ramanan Balakrishnan [Get Unlimited Access to Postgres Online Training Content for a Year](http://info.enterprisedb.com/rs/069-ALB-339/images/EDB_Training_eSubscriptions_DS.pdf)EDB Postgres Training e-Subscriptions simplify how you purchase and consume training. Get unlimited access. EnterpriseDB#sponsored [pglogical 2.1 Released: Logical Replication for Postgres 10](https://www.postgresql.org/about/news/1790/?utm_source=postgresweekly&utm_medium=email) 2ndQuadrant#tools [hypopg 1.1.0: Hypothetical Indexes for Postgres 10](https://github.com/dalibo/hypopg?utm_source=postgresweekly&utm_medium=email)An extension which adds _hypothetical_ indexes so you can see if Postgres would use them for your queries. Now updated for Postgres 10. Dalibo#code Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/228) [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