---
title: "Setting up Streaming Replication in Postgres"
publication: "Postgres Weekly"
issue: 273
published_at: "2018-09-12"
canonical_url: "https://postgresweekly.com/issues/273"
---

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

#273 — September 12, 2018 

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

Postgres Weekly 

[![\](https://res.cloudinary.com/cpress/image/upload/w_1280,e_sharpen:60/jvoylbq2lfxr9a5fdtfq.jpg)](https://www.citusdata.com/blog/2018/09/11/postgresql-11-just-in-time/)  

[Postgres 11 and Just In Time (JIT) Query Compilation](https://www.citusdata.com/blog/2018/09/11/postgresql-11-just-in-time/) — Postgres 11 includes a new JIT expression compiler which shows up to a 29.31% speed improvement executing TPC-H Q1 at a scale factor of 10 in 20.5s (instead of 29s with Postgres 10.) 

Dimitri Fontaine   

[Setting up Streaming Replication in Postgres](https://www.percona.com/blog/2018/09/07/setting-up-streaming-replication-postgresql/) — Postgres’s streaming replication functionality continuously sends write-ahead logs to other servers to keep them current. Here are the basic steps to set it up. 

Avinash Vallarapu (Percona)   [![\](https://copm.s3.amazonaws.com/cc98744f.png)](https://www.jackdb.com/) 

[JackDB: A Modern Database Client for Postgres](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   

[ZomboDB: Making Postgres and Elasticsearch Work Together](https://github.com/zombodb/zombodb) — Brings powerful text-search and analytics features to Postgres by using Elasticsearch as an index type. It’s in beta and integrates with Postgres’ index access mechanisms. 

ZomboDB   

[What is the 'CHAR' Type Good For?](https://thebuild.com/blog/2018/09/04/char-what-is-it-good-for/) — _“It’s little used… and that’s for a reason.”_ Basically, you almost certainly don’t need to use `CHAR` instead of `VARCHAR` and here’s why. 

Christophe Pettus   

[Upgrading to Postgres 11 with Logical Replication](https://blog.2ndquadrant.com/upgrading-to-postgresql-11-with-logical-replication/) — Postgres 11 isn’t quite here yet ([beta 3](https://www.postgresql.org/about/news/1878/) is the latest release) but if you want to be prepared.. 

Peter Eisentraut   

[Parallel PostGIS and PgSQL 11](http://blog.cleverelephant.ca/2018/09/parallel-postgis-3.html) — The forthcoming Postgres 11 opens up a lot of opportunities for improved parallel execution and this is also true with geospatial queries, though but there are consequences to consider. 

Paul Ramsey   

[How to Create a 'Remove Duplicates' Trigger Function](https://medium.com/@emery_44439/how-to-create-a-postgresql-remove-duplicates-trigger-function-afbf982e2bea) 

Emery Silberman   

[Postgres Data Types You Should Consider Using](https://www.citusdata.com/blog/2018/08/29/datatypes-you-should-consider-using/) — Postgres has a rich set of nearly 100 data types. Here’s a rundown of a few that you may not be using yet but should consider. 

Craig Kerstiens   

[Using Custom SQL Functions for Queries with Postgres and GraphQL](https://blog.hasura.io/using-custom-sql-functions-for-queries-with-postgres-and-graphql-ddca6caf6681) — Run business logic in the database using custom SQL functions triggered by a GraphQL insert mutation when using Hasura’s GraphQL engine. 

Rikin Kachhia   

[Webinar 9/25 - Free Monitoring for PostgreSQL](https://severalnines.com/resources/webinars/free-monitoring-steroids-mysql-mariadb-postgresql-and-mongodb?utm_campaign=ClusterControl_Campaign_SEP_2018&utm_content=webinar&utm_medium=Paid_Search&utm_source=banner) 

Severalnines sponsor   

[pgsocket: A Simple TCP/IP Socket Client for Postgres 10](https://abdulyadi.wordpress.com/2018/09/11/pgsocket-extension-for-simple-socket-client/) — An unusual extension but potentially of interest to _someone_. It lets you use a function in your queries to send TCP packets. 

Abdul Yadi  

Events  

[PostgresConf Silicon Valley](https://postgresconf.org/conferences/SiliconValley2018) — **October 15-16 (San Jose, CA)** The perfect opportunity for all walks of Postgres life to connect, lead and learn all about Postgres and the related ecosystem.    

[PostgreSQL Conference Europe 2018](https://2018.pgconf.eu/) — **October 23-26 (Lisbon, Portugal)** The 10th Annual PostgreSQL Conference Europe which will be held at the Lisbon Marriott Hotel.    

[FOSDEM PGDay 2019](https://2019.fosdempgday.org/) — **February 1, 2019 (Brussels, Belgium)** An extension to the regular PostgreSQL activities at FOSDEM.         

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