---
title: "#239: PostgreSQL Meltdown - What's The Effect on Performance? "
publication: "Postgres Weekly"
issue: 239
published_at: "2018-01-17"
canonical_url: "https://postgresweekly.com/issues/239"
---

Postgres Weekly 239   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 239 — January 17, 2018     

[PostgreSQL Meltdown: What's The Effect on Performance?](https://blog.2ndquadrant.com/postgresql-meltdown/)How have the fixes for the recent Spectre and Meltdown CPU vulnerabilities affected Postgres performance? This first look suggests about a 7% performance hit. 2ndQuadrant#news [Graphile: Instant GraphQL APIs for Postgres Databases](https://www.graphile.org/)Auto-discovers tables, columns, relations, procedures and more, then runs a high-performance secure GraphQL API server that adheres to best practices. Benjie Gillam#tools [PostgresConf US 2018: The Postgres Ecosystem Conference](https://postgresconf.org/#2018)Join a diverse class of over 700 hundred Postgres professionals from around the world for the the preeminent “People, Postgres and Data” experience. PostgresConf.​Org#sponsored[![\](https://copm.s3.amazonaws.com/3e32512d.png)](https://postgresconf.org/#2018) [PostgreSQL Configuration for Humans](https://www.youtube.com/watch?v=IFIXpm73qtk)No tuning equals below par performance. But which parameters to tune? This talk looks at the performance advantages of appropriately tuning your postgresql.conf file. Alvaro Hernandez#video [Indexing with Postgres: When Less is More](https://medium.com/plangrid-technology/indexing-with-postgres-when-less-is-more-7337d6f09048)Indexes are pretty easy to add and should speed up query performance, except sometimes it's more complicated. This deep dive is a great look at analyzing query and index perf. Nathan Yergler [Exploring SP-GiST and BRIN Indexes Visually using pg_hexedit](https://pgeoghegan.blogspot.com/2018/01/exploring-sp-gist-and-brin-indexes.html)[pg_hexedit](https://github.com/petergeoghegan/pg_hexedit) makes it possible to edit Postgres relation files from a hex editor. Peter Geoghegan [Advanced Postgres Internals: Building a Description Tool](https://www.dataquest.io/blog/postgres-internals/)In this post, learn about Postgres’ internal tables and use Python to build your own description dictionary from scratch. Dataquest [Go Deep into Today’s Modern Data Tier to See the Root of the Problem Fast](https://selectstar.io/root/?utm_source=CooperPress&utm_medium=Brief+Link&utm_campaign=Postgres+Weekly+Brief+Link+Jan17) SelectStar#sponsored [Database Sharding Explained in Plain English](https://www.citusdata.com/blog/2018/01/10/sharding-in-plain-english/) Craig Kerstiens [Migrations and Long Transactions in Postgres](https://blog.fin.com/migrations-and-long-transactions-in-postgres-e6c3fbae56a5)_“When running backfills or any long job it’s crucial to be conscious of how long any particular transaction will be running, and do a better of chunking the work into separate queries if possible.”_ Sidharth Shanker [PL/Swift: Write Custom Postgres Functions in Swift](http://www.alwaysrightinstitute.com/plswift/) The Always Right Institute#tools [pglogical 2.1.1: A Logical Replication Postgres Extension](https://www.postgresql.org/about/news/1821/) 2nd Quadrant#tools [Tune Your PostgreSQL Cloud Instance on Amazon RDS for Your Workload](https://www.enterprisedb.com/services/tune-service-postgresql-amazon-rds) EnterpriseDB Tune-Up Service#sponsored    

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