---
title: "🐘 #229: A Tour of Postgres Index Types"
publication: "Postgres Weekly"
issue: 229
published_at: "2017-10-18"
canonical_url: "https://postgresweekly.com/issues/229"
---

Postgres Weekly 229   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 229 — October 18, 2017     

[A Tour of Postgres Index Types](https://www.citusdata.com/blog/2017/10/17/tour-of-postgres-index-types/?utm_source=postgresweekly&utm_medium=email)Postgres has a rich set of index types from standard b-tree to GIN and GiST. Here’s a tour of all the index types in Postgres and when you’d want to use each. Craig Kerstiens [PostgreSQL 10 Now in Beta on Heroku Postgres](https://blog.heroku.com/postgres-10-beta?utm_source=postgresweekly&utm_medium=email)Looking to give Postgres 10 a try? Heroku Postgres now has beta support for the newly released version. Heroku#news [2Q PGConf: PostgreSQL Training with Experts](http://www.2qpgconf.com)Receive hands on PG training with local 2ndQuadrant experts at 2Q PGConf 2017 in New York on Nov 6. Courses include: PostgreSQL Database Security, Postgres-BDR, and Postgres-XL. Discount for this date. 2ndQuadrant#sponsored[![\](https://copm.s3.amazonaws.com/4b942279.jpg)](http://www.2qpgconf.com) [Set Returning Functions and Postgres 10](http://tapoueh.org/blog/2017/10/set-returning-functions-and-postgresql-10/?utm_source=postgresweekly&utm_medium=email)A Set Returning Function is a stored procedure that can be used as a relation: from a single call it returns an entire result set. Postgres 10 brings some new benefits to them which you can dig into here. Dimitri Fontaine ['Dear Postgres': A Love Letter to Postgres](http://www.craigkerstiens.com/2017/10/12/dear-postgres/?utm_source=postgresweekly&utm_medium=email).. from a long-time user you might have heard of :-) Give a read to this letter on all Postgres has brought over the years. Craig Kerstiens#news [repmgr 4.0 Beta: Streaming Replication Management for Clusters](https://www.postgresql.org/about/news/1793/?utm_source=postgresweekly&utm_medium=email)Version 4 updates repmgr to support the recently released Postgres 10. Postgres.​org#news [How to Set Up a Postgres Database on a Raspberry Pi](https://opensource.com/article/17/10/set-postgres-database-your-raspberry-pi?sc_cid=701f2000000tiAAAAY&_lrsc=b84413a5-ccd2-4ee5-9389-90b474140a1a&utm_source=postgresweekly&utm_medium=email)Postgres is a reliable database that can run anywhere including smaller devices. Have a use for it on a Raspberry Pi? Here is your guide to getting it up and running. Ben Nuttall [The Best Features of Postgres 10 for Database Administrators](http://www.cybertec.at/best-of-postgresql-10-for-the-dba/?utm_source=postgresweekly&utm_medium=email) Kaarel Moppel#opinion [Why PostgreSQL Is Better Than MySQL](https://blog.2ndquadrant.com/postgresql-better-mysql-1/?utm_source=postgresweekly&utm_medium=email)Hint: It’s something to do with bugs. Simon Riggs#opinion [Lower Risk & Speed Time to Market With Structured Postgres Training](http://inter.viewcentral.com/reg/enterprisedb/PostgresAdvancedTraining)Performance tune your PG skills. Train on Postgres with EDB, & be prepared to succeed. EnterpriseDB#sponsored [amcheck: Functions for Verifying Postgres Relation Integrity](https://github.com/petergeoghegan/amcheck/?utm_source=postgresweekly&utm_medium=email) Peter Geoghegan#code    

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