---
title: "High Availability and Scalable Reads in Postgres"
publication: "Postgres Weekly"
issue: 255
published_at: "2018-05-09"
canonical_url: "https://postgresweekly.com/issues/255"
---

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

#255 — May 9, 2018 

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

Postgres Weekly  

[High Availability and Scalable Reads in Postgres](https://blog.timescale.com/scalable-postgresql-high-availability-read-scalability-streaming-replication-fb95023e2af) — A detailed primer on streaming replication, complete with performance measurements. 

Lee Hampton   

[The 'Point' Data Type in Postgres](https://tapoueh.org/blog/2018/05/postgresql-data-types-point/) — Continuing his series on Postgres data types, Dimitri takes a thorough look at `point`, a data type to represent a position on a 2D plane (i.e. X, Y coordinates). 

Dimitri Fontaine   [![\](https://copm.s3.amazonaws.com/6e24c1f0.png)](https://learn.percona.com/why-postgresql) 

[Why PostgreSQL? An Overview of the Features that Make PostgreSQL Unique](https://learn.percona.com/why-postgresql) — Discover some of the essential features of PostgreSQL that can help your business today. 

Percona sponsor   

[Avoiding 'OR' for Better Query Performance](https://www.cybertec-postgresql.com/en/avoid-or-for-better-performance/) — A look at different kinds of queries using SQL’s `OR` and how to rewrite them without OR for better performance on Postgres. 

Laurenz Albe   

[PostgreSQL at the Linux Storage, Filesystem, and Memory-Management Summit](https://lwn.net/SubscriberLink/752952/6825e6a1ddcfb1f3/) — An interesting update on the recent [Postgres’s fsync() surprise](https://lwn.net/Articles/752063/) issue and what options and solutions are in the pipeline. 

LWN   

[All About Tablespaces in Postgres](https://pgdash.io/blog/tablespaces-postgres.html?h) — Tablespaces essentially let you control the disk/file layout of a Postgres database, so you could place certain indexes on faster disks, etc. 

RapidLoop    

[How Analysis Helped Make a Query 290 Times Faster](https://medium.com/@yuliaoletskaya/how-postgresql-analysis-helped-to-gain-290-times-performance-boost-for-a-particular-request-938dc69580da) — The quick tale of making a single query 290x faster by working with EXPLAIN ANALYZE. 

Yulia Oletskaya   

[Experiences with Running Postgres on Kubernetes](https://medium.gravitational.com/experiences-with-running-postgresql-on-kubernetes-802d6ada7aef) — An interview that contains some tips on how to approach running Postgres within Kubernetes. 

Gravitational   

[It's The Future (for Databases)](https://www.citusdata.com/blog/2018/05/08/its-the-future-for-databases/) — What does the future hold for databases? It may or may not have something to do with Postgres. 

Craig Kerstiens   

[Real-Time Postgres Performance Monitoring. Try Datadog Free](https://www.datadoghq.com/postgres-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-PostgresWeeklyB) 

Datadog sponsor   

[Running ANALYZE in Parallel on Postgres Databases](http://pgyogesh.com/blog/postgresql/python/parallel-analyze-postgres/) — A Python tool to run analyze on multiple tables in parallel. 

Yogesh Jadhav   

[pgfutter: Import CSV and JSON Into Postgres The Easy Way](https://github.com/lukasmartinelli/pgfutter) 

Lukas Martinelli   

[The Best Extract, Transform & Load Tools for Migrating to Postgres](https://severalnines.com/blog/best-etl-tools-migrating-postgresql) — What ETL is and what tools are available to help you migrate your data to Postgres. 

Venkata Nagothi  

Events  

[Postgres Vision 2018](http://postgresvision.com/) — **June 5-6 (Boston, USA)** Postgres in the Cloud - Front and center at Postgres Vision 2018.    

[PGDay.IT 2018](https://2018.pgday.it/it/) — **June 28 - 29 (Pacengo di Lazise, Italy)** The Italian conference dedicated to PostgreSQL.    

[PGConf UK 2018](https://www.postgresql.org/about/event/2224/) — **July 2- 3 (London, UK)** Will be held on July 3, with an optional training day on July 2, and will be hosted at 30 Euston Square.          

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