---
title: "Installing and Configuring JIT in Postgres 11"
publication: "Postgres Weekly"
issue: 284
published_at: "2018-12-05"
canonical_url: "https://postgresweekly.com/issues/284"
---

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

#284 — December 5, 2018 

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

Postgres Weekly  

[What's New in PostgreSQL 11](https://severalnines.com/blog/whats-new-postgresql-11) — Postgres 11 landed about [6 weeks ago](https://postgresweekly.com/issues/279) but in case you haven’t played with it yet, this post gives an overview of the new features and functions. 

Viorel Tabara   

[Transactions in PostgreSQL: `READ COMMITTED` vs. `REPEATABLE READ`](https://www.cybertec-postgresql.com/en/transactions-in-postgresql-read-committed-vs-repeatable-read/) — The SQL standard proposes different transaction isolation levels (e.g. `READ COMMITTED` and `REPEATABLE READ`) to control the behavior of the database engine with regards to reading data being committed in concurrently running transactions. 

Hans-Jürgen Schönig   [![\](https://copm.s3.amazonaws.com/11b09ec3.png)](https://www.enterprisedb.com/edb-postgres-cds) 

[Announcing The EDB Postgres Cloud Database Service Beta](https://www.enterprisedb.com/edb-postgres-cds) — A complete managed service, delivering enterprise-ready EDB Postgres databases on the Amazon Web Services (AWS) Cloud. 

EnterpriseDB sponsor   

[Installing and Configuring JIT in Postgres 11](https://www.percona.com/blog/2018/11/19/installing-and-configuring-jit-in-postgresql-11/) — Just-In-Time (JIT) compilation for SQL statements came to Postgres 11 as an option to Postgres 11 but as not all workloads can benefit from it, it’s not enabled by default. Here’s how you can get it running to see if it benefits you. 

Jobin Augustine   

[AgensGraph 2.0: A Multi-Model Graph Database for Postgres](https://www.postgresql.org/about/news/1909/) — AgensGraph is a graph database (supporting both SQL and Cypher queries) built atop Postgres. [GitHub repo.](https://github.com/bitnine-oss/agensgraph) 

Bitnine   

[`psql` on Postgres 12 Gains Simple CSV Output Feature](http://okbob.blogspot.com/2018/11/postgresql-12-psql-csv-output.html) 

Pavel Stěhule   

[Combining pgBackRest and Streaming Replication](https://pgstef.github.io/2018/11/28/combining_pgbackrest_and_streaming_replication.html) — [pgBackRest](https://pgbackrest.org/) is a powerful backup and restore tool for Postgres. 

Stefan Fercot   

[Postgres 12 Feature Highlight: DOS Prevention](https://paquier.xyz/postgresql-2/postgres-12-dos-prevention/) — It’s possible to lock up a Postgres database with certain queries, and fixes are on the way in Postgres 12. 

Michael Paquier   

[PostgreSQL Streaming Physical Replication With Slots](https://www.percona.com/blog/2018/11/30/postgresql-streaming-physical-replication-with-slots/) — Physical Postgres replication is based around the Write Ahead Log (WAL) and _slots_, introduced in Postgres 9.4, enable a master server to keep track of the state of replicas and retain WAL segments they might need. 

Nickolay Ihalainen   

[Managing High Availability in Postgres](https://scalegrid.io/blog/managing-high-availability-in-postgresql-part-1/) — The first in a three part series on how to manage high availability using streaming replication via open source tools for automatic failover, monitoring and replication. 

Madan Kumar K   

[Why Citus Data Is Donating 1% Equity to the PostgreSQL Non-Profits](https://www.citusdata.com/blog/2018/10/24/why-citus-data-is-donating-1-percent-equity/?utm_source=PG_Weekly&utm_medium=email&utm_campaign=sponsor_blog) — The Citus Data co-founders share why they’re giving a piece of their future success to the Postgres community. 

CITUS DATA sponsor   

▶[Postgres and Kubernetes: DBaaS Without Vendor Lock-In](https://www.youtube.com/watch?v=q26U2rQcqMw&feature=share) — A 30 minute talk on using Kubernetes to create your own Postgres-powered database as a service. 

Oleksii Kliukin  

🗓 Events  

[Pg Down Under 2018](https://2018.pgdu.org/) — **December 7 (Melbourne, Australia)** PG Down Under 2018 is the second annual conference which provides a unique opportunity for PostgreSQL Developers and Users to meet, learn, grow relationships.   

[PGConf.ASIA 2018](https://www.pgconf.asia/EN/2018/) — **Decemeber 10-12 (Tokyo, Japan)** The largest PostgreSQL event in Asia.   

[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