---
title: "#253: Postgres 10, Performance and You"
publication: "Postgres Weekly"
issue: 253
published_at: "2018-04-25"
canonical_url: "https://postgresweekly.com/issues/253"
---

The latest Postgres news, articles, tools, and projects.       

#253 — April 25, 2018 

[Read on the Web](https://postgresweekly.com/issues/253)   

Postgres Weekly  

[Date, Timestamp, and Time Zones in Postgres](https://tapoueh.org/blog/2018/04/postgresql-data-types-date-timestamp-and-time-zones/) — Dimitri Fontaine continues to walk through the various Postgres datatypes. Here we see how easy and valuable working with time directly in Postgres can be. 

Dimitri Fontaine   

[Postgres 10, Performance and You](https://speakerdeck.com/genslein/postgres-10-performance-and-you) — ‘Only’ a slidedeck for now, but they do a great job of summarizing some of the new performance-impacting features in Postgres 10 and 9.6. 

Gabriel Enslein   [![\](https://copm.s3.amazonaws.com/cc98744f.png)](https://www.jackdb.com/) 

[JackDB: A Modern Database Client](https://www.jackdb.com/) — JackDB is a web-based database client with built-in tools for security and collaboration. Sign up for a free trial today. 

JackDB, Inc. sponsor   

[The Official Postgres Homepage Gets a Redesign](https://www.postgresql.org/) — The first major redesign in a _long_ time. It’s clean, simple, and responsive. You can still see the older layout [in the docs section](https://www.postgresql.org/docs/10/static/index.html) if you want to compare. 

PostgreSQL Global Development Group   

[PostgreSQL's fsync() Surprise](https://lwn.net/SubscriberLink/752063/181dbb4b9d2820f5/) — When IO errors occur and Postgres isn’t notified, databases can get corrupted. What’s in the future for dealing with this? _P.S. LWN is usually a subscriber-only site, so if you like their stuff, consider signing up._ 

LWN    

[Google Cloud SQL for PostgreSQL Now Generally Available](https://cloudplatform.googleblog.com/2018/04/Cloud-SQL-for-PostgreSQL-now-generally-available-and-ready-for-your-production-workloads.html) — Backed by Google’s 24x7 SRE team, high availability with automatic failover, and SLA. It’s based around standard Postgres, supports [lots of useful extensions](https://cloud.google.com/sql/docs/postgres/extensions) and works on instances with up to 416GB of RAM. 

Google Cloud Platform   

[Has The Time Finally Come for PostgreSQL?](https://www.zdnet.com/article/has-the-time-finally-come-for-postgresql/) — Postgres has long been a solid database, many have used it reliably for year and now it’s time may be here for us in larger enterprise situations. 

ZDNet   

[Postgres as the Substructure for IoT and the Next Wave of Computing?](https://blog.timescale.com/postgres-accidental-iot-platform-timescaledb-postgresql-time-series-data-7983d28da5af) — How PostgreSQL accidentally became the ideal platform for IoT applications and services. 

Ajay Kulkarni   

[Upgrading Postgres from 9.4 to 10.3 with pglogical](https://hunleyd.github.io/posts/Upgrading-PostgreSQL-from-9.4-to-10.3-with-pglogical/) 

Douglas J Hunley   

[Getting Started with Patroni for Highly Available Postgres](https://www.opsdash.com/blog/postgres-getting-started-patroni.html) — Postgres comes with built-in replication, but it doesn’t have out of the box HA. One of the more popular solutions for implementing HA with Postgres is Patroni. 

OpsDash   

[Anonymising Email Addresses for GDPR and Safe Development](http://petegraham.co.uk/anonymising-user-emails-with-sql-in-postgres/) — A simple SQL statement to update a user table. 

Pete Graham   

[Percona Expands Services Offerings with PostgreSQL Support](https://www.percona.com/about-percona/newsroom/press-releases/percona-expands-services-offerings-postgresql-support) 

Percona sponsor   

[How To Index Your Database](https://www.xaprb.com/talks/index-postgresql-database-postgresconf-2018/) — Think you knew about indexes, the slides from this recent talk may still teach you a thing or two. A great guide on foundational principles as well as practical tips. 

Baron Schwartz         

Curated by [Cooperpress](https://cooperpress.com/) and [Craig Kerstiens](https://twitter.com/craigkerstiens) 

[Change your email address](https://postgresweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://postgresweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom