---
title: "A look at Postgres index internals, and benchmarking Postgres on different Linux kernel versions"
publication: "Postgres Weekly"
issue: 169
published_at: "2016-08-10"
canonical_url: "https://postgresweekly.com/issues/169"
---

Postgres Weekly 169   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 169 — August 10, 2016     

[Benchmarking Postgres on Multiple Linux Kernel Versions](http://blog.2ndquadrant.com/postgresql-vs-kernel-versions/?utm_source=postgresweekly&utm_medium=email)Comparing Postgres performance across different memory or CPU configurations is common, but does the Linux kernel version used make a difference under otherwise similar conditions? To a point, yes. Tomas Vondra#opinion [Sharding A Multi-Tenant App with Postgres](https://www.citusdata.com/blog/2016/08/10/sharding-for-a-multi-tenant-app-with-postgres/?utm_source=postgresweekly&utm_medium=email)If you reach a point that you need to scale beyond a single node, sharding becomes an appealing option. If you have a multi-tenant application, this post will help with how you should approach modelling your data. Citus Data [A Look at Postgres' Index Internals](https://www.pgcon.org/2016/schedule/events/934.en.html?utm_source=postgresweekly&utm_medium=email)Postgres is rich with index types, B-Tree for standard tables, GIN for [full text search](https://blog.lateral.io/2015/05/full-text-search-in-milliseconds-with-postgresql/) and JSONB, GiST for PostGIS. And if you’re curious on what actuallly happens under the covers there’s much more you can learn. This PgCon talk (videos and slides available) is a great guide to how the internals of index types work. Heikki Linnakangas [Try Compose PostgreSQL, get a free tshirt!](https://www.compose.com/articles/try-postgresql?utm_source=cooper&utm_medium=postgres-newsletter&utm_campaign=postgresql-tshirt)This month only, we're giving away free tshirts for all new deployments of Compose PostgreSQL. It takes just a couple minutes to signup and deploy a HA, 3-node Postgres cluster with daily backups and autoscaling. [Give it a try.](https://www.compose.com/articles/try-postgresql?utm_source=cooper&utm_medium=postgres-newsletter&utm_campaign=postgresql-tshirt) Compose#sponsored[![\](https://copm.s3.amazonaws.com/b6d2ce9c.jpg)](https://www.compose.com/articles/try-postgresql?utm_source=cooper&utm_medium=postgres-newsletter&utm_campaign=postgresql-tshirt) [Thoughts on Uber’s List of Postgres Limitations](http://blog.2ndquadrant.com/thoughts-on-ubers-list-of-postgres-limitations/?utm_source=postgresweekly&utm_medium=email)In what may be the last of the responses to Uber’s post on moving from Postgres to MySQL, Simon Riggs of the Postgres core team takes a look at each of the major issues, provides a response, and best of all gives some insight for how Postgres roadmap may help address them. Simon Riggs [A 'Simple Moving Objects' Database with Postgres](https://zejn.net/b/2016/08/08/simple-moving-objects-database-with-postgres/?utm_source=postgresweekly&utm_medium=email)A guide for how you can deal with geospatial objects and track them over time. Gašper Žejn#tutorial [Backing Up Tablespaces and Streaming WAL with PGHoard](http://blog.aiven.io/2016/07/pghoard-tablespaces-wal-stream.html?utm_source=postgresweekly&utm_medium=email)Version 1.4.0 of PGHoard arrives with support for PostgreSQL 9.6 beta3, StatsD and DataDog metric support and more. Oskari Saarenmaa [Scheduled Postgres to Redshift Copy with a Simple Heroku App](https://medium.com/carwow-product-engineering/scheduled-postgres-to-redshift-copy-with-a-simple-heroku-app-c7d9a614e738?utm_source=postgresweekly&utm_medium=email) Federico Rebora#tutorial [1M Rows/s from Postgres to Python](http://magic.io/blog/asyncpg-1m-rows-from-postgres-to-python/?utm_source=postgresweekly&utm_medium=email)A look at a new Python Postgres client focused on speed that reaches some impressive numbers for reading data. Elvis Pranskevichus and Yury Selivanov [Advanced SQL in Rails](http://brewhouse.io/2016/08/04/sql-in-rails.html?utm_source=postgresweekly&utm_medium=email)ORMs can be nice to work with and you don’t always have to sacrifice the power of SQL when working with them. Here’s the first part of a series looking at taking advantage of more powerful SQL, like window functions, within Rails. brewhouse [Stop Applying to Jobs - Let Companies Come To You](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-postgresweekly)On Hired, engineers typically get 5+ job offers in 1 week. Find that new opportunity you've been craving and get access to 4,000+ companies instantly. Hired.​com#job    

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