---
title: "#208: PostgreSQL 10 Beta 1 Released"
publication: "Postgres Weekly"
issue: 208
published_at: "2017-05-24"
canonical_url: "https://postgresweekly.com/issues/208"
---

Postgres Weekly 208   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 208 — May 24, 2017     

[PostgreSQL 10 Beta 1 Released](https://www.postgresql.org/about/news/1749/?utm_source=postgresweekly&utm_medium=email)PostgreSQL 10 has all the new features it’s going to get, which excitingly includes improvements to logical replication and table partitioning. If you’re excited to give it a try the Beta has been released so you can start to give it a spin today. PostgresQL.​ORG#news [PostgresOpen SV 2017 Registration Opens; 1 Week for CFP](https://www.postgresql.org/about/news/1750/?utm_source=postgresweekly&utm_medium=email)Postgres Open SV, the convergence of PG Open and PGConf SV, is happening right in downtown San Francisco this year. Early bird registration just opened and there’s still time left to get in for the CFP. postgresql.​org#news [Autonomous Transactions Using 'pg_background'](https://www.openscg.com/2017/05/postgresql-autonomous-transactions-pg_background/?utm_source=postgresweekly&utm_medium=email)Postgres doesn’t directly support sub-transactions (where, say, one table gets rolled back but another is updated) but there’s an extension to help with that. David Rader [Because Your Data Is Your Business](http://www.PGExperts.com)PGX's open source experts provide the database and application skills necessary to solve database problems, accelerate existing applications, refactor infrastructure, and develop new applications. PostgreSQL Experts, Inc.​ #sponsored[![\](https://copm.s3.amazonaws.com/bf274a23.png)](http://www.PGExperts.com) [How Basic Performance Analysis Saved Us Millions](http://heap.engineering/basic-performance-analysis-saved-us-millions/?utm_source=postgresweekly&utm_medium=email)A look at how some performance analysis using flame graphs and ensuring some efficient indexing improved performance and saved a good amount of money. Michael Malis [Bootstrapping Postgres Users](https://tech.instacart.com/bootstrapping-postgres-users-cd594e5f28e9?utm_source=postgresweekly&utm_medium=email)Postgres has a reasonable role management scheme out of the box, but it’s not every day you setup a new app and users. This primer helps you get started for what you may need on a new or existing app. Instacart [PostgreSQL and Tablespaces, It's Not So Scary](http://www.cybertec.at/postgresql-tablespaces-its-not-so-scary/?utm_source=postgresweekly&utm_medium=email)What are tablespaces? Why and how to use them? Here you can find the answers you need to use tablespaces and get the most out of them. Kaarel Moppel [temporal_tables: An Extension to Add 'Temporal Tables'](https://github.com/arkhipov/temporal_tables?utm_source=postgresweekly&utm_medium=email)A temporal table is a table that records the period of time when a row is valid. Vlad Arkhipov#code [Ora2Pg: A Tool to Move Oracle Databases to PostgreSQL](http://ora2pg.darold.net/?utm_source=postgresweekly&utm_medium=email)A free tool used to migrate an Oracle or MySQL database to a Postgres-compatible schema. Ora2Pg#tools [ToroDB: A Layer That Turns Postgres Into a NoSQL Database](https://github.com/torodb/server?utm_source=postgresweekly&utm_medium=email) ToroDB#tools [Monitor Postgres in real time](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeekly)Visualize 50+ key Postgres metrics, correlate with 150+ other techs, detect bottlenecks, and alert on issues. Datadog#sponsored    

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