---
title: "This Week's PostgreSQL News (#172)"
publication: "Postgres Weekly"
issue: 172
published_at: "2016-08-31"
canonical_url: "https://postgresweekly.com/issues/172"
---

Postgres Weekly 172   . 

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

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

[The Sizes of FTS Indices](http://obartunov.livejournal.com/189690.html?utm_source=postgresweekly&utm_medium=email)Postgres has a number of index types - each with a different focus and tradeoffs. Here’s a look at a newer type, the RUM index, which may be larger but can provide some performance improvements. Oleg Bartunov [PgSQL Indexes and LIKE Queries](http://blog.cleverelephant.ca/2016/08/pgsql-text-pattern-ops.html?utm_source=postgresweekly&utm_medium=email)Indexes in general make your queries faster. One common case for applications is `LIKE %foo` queries, and in some cases they can work and others not. This post lays out what you need to know to take advantage of them. Paul Ramsey#tutorial [HTTP API to Read & Write Excel files](https://www.cloudxls.com/?utm_source=pgweekly&utm_content=landing&utm_campaign=rw201609)Turn messy CSV dumps into user-friendly and native Excel spreadsheets. cloudxls#sponsored[![\](https://copm.s3.amazonaws.com/fdc02999.png)](https://www.cloudxls.com/?utm_source=pgweekly&utm_content=landing&utm_campaign=rw201609) [Django and PostgreSQL: An Even-Closer Union](https://www.youtube.com/watch?v=xGkH2yoy2MY&utm_source=postgresweekly&utm_medium=email)Christophe Pettus demonstrates Django 1.8 and 1.9’s Postgres-related features. _20 minutes_. DjangoCon US#video [PostgreSQL vs Hadoop](http://ledgersmbdev.blogspot.co.uk/2016/08/postgresql-vs-hadoop.html?utm_source=postgresweekly&utm_medium=email) Chris Travers#opinion [Building a Scalable Postgres Metrics Backend using the Citus Extension](https://www.citusdata.com/blog/2016/08/30/citus-clouds-usage-of-citus-cloud/?utm_source=postgresweekly&utm_medium=email) Will Leinweber#tutorial [pg_tail: 'tail -f' Your PostgreSQL Tables](https://github.com/aaparmeggiani/pg_tail?utm_source=postgresweekly&utm_medium=email) Andre Parmeggiani#tools [csv2table: A CSV to Postgres Loader](http://blog.ryankelly.us/2016/08/28/csv2table.html?utm_source=postgresweekly&utm_medium=email)While Postgres copy can work great, sometimes you want something simpler. Here’s a utility for loading directly from a CSV into a table, creating it and all. Ryan Kelly#tools [Accessing Multiple Postgres Schemas from Django](https://www.amvtek.com/blog/posts/2014/Jun/13/accessing-multiple-postgres-schemas-from-django/?utm_source=postgresweekly&utm_medium=email)Schemas allow some logical separation of tables within Postgres, which can be nice for a number of reasons. Django only requires a bit of work to be able to work with them as highlighted here. AmvTek blog [A Table of Postgres Data Types to Redshift Data Types](https://gist.github.com/wrobstory/4b0ce4e8ba51ec40c494881bc126c003?utm_source=postgresweekly&utm_medium=email) Rob Story [Get 5+ Engineering Job Offers in 1 Week](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q3-16-postgresweekly)With Hired, companies apply to hire you - get salary and equity offers before you interview from companies like Facebook, Postmates, & Square Hired.​com#job    

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