---
title: "This Week's PostgreSQL News (#112)"
publication: "Postgres Weekly"
issue: 112
published_at: "2015-07-01"
canonical_url: "https://postgresweekly.com/issues/112"
---

Postgres Weekly 112   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 112 — July 1, 2015     

[Introducing HypoPG, Hypothetical Indexes for PostgreSQL](http://www.postgresql.org/about/news/1593/?utm_source=postgresweekly&utm_medium=email)Want to know if an index will be useful before you create it? Here’s an extension to help with just that, by hypothetically creating an index before it actually writes it out. Great to see if an index will be useful ahead of time! Postgresql.​org#news [How to Aggregate Data with PostgreSQL using Window Functions](http://blog.elpassion.com/aggregate-data-postgresql/?utm_source=postgresweekly&utm_medium=email)If you’re doing any level of complex or even moderately complex aggregation across your data, window functions are hugely useful. Here’s an example of how you can use them. Adrian Serafin#tutorial [Showing 'Similar' Results in Postgres](http://www.leighhalliday.com/showing-results-for-trigrams-in-postgres?utm_source=postgresweekly&utm_medium=email)Want your application’s search to be a bit more flexible than perfectly matching what the user entered? Postgres has some built in flexibility for finding ‘similar’ words and sounds. Leigh Halliday#tutorial [VividCortex and PostgreSQL Monitoring](http://t.signauxhuit.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XYg4WJ3rsN6448bPf6xSsW2BgSpx56dQQddQpf6002?t=https%3A%2F%2Fvividcortex.com%2Fmonitoring%2Fpostgres%2F%3Futm_source%3Dpaid%26utm_medium%3Dpgw&si=6148852320567296&pi=8b0b3550-40de-4aeb-c65d-3fe10a6ae6a8)VividCortex is the easiest, safest, and most detailed way to monitor PostgreSQL. Unlike other tools that just capture a few status metrics, VividCortex measures every query, every process, and every metric on your entire system, down to the microsecond to improve performance. VividCortex#sponsored[![\](https://copm.s3.amazonaws.com/2a010466.png)](http://t.signauxhuit.com/e1t/c/5/f18dQhb0S7lC8dDMPbW2n0x6l2B9nMJW7t5XYg4WJ3rsN6448bPf6xSsW2BgSpx56dQQddQpf6002?t=https%3A%2F%2Fvividcortex.com%2Fmonitoring%2Fpostgres%2F%3Futm_source%3Dpaid%26utm_medium%3Dpgw&si=6148852320567296&pi=8b0b3550-40de-4aeb-c65d-3fe10a6ae6a8) [Postgres 9.5 Feature Highlight: archive_mode = always](http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-archive-mode-always/?utm_source=postgresweekly&utm_medium=email) Michael Paquier#news [Searching Serialized Fields in Rails Using Postgres Arrays](http://viget.com/extend/searching-serialized-fields-in-rails-using-postgres-arrays?utm_source=postgresweekly&utm_medium=email)If you’re using Arrays or other more unique datatypes, the default WHERE when searching isn’t going to be your ideal. Fortunately there is a better option that works great in Postgres, here’s how to take advantage of it in Rails directly. viget.​com#tutorial [Optimizing Full Text Search with Postgres tsvector Columns and Triggers](https://robots.thoughtbot.com/optimizing-full-text-search-with-postgres-tsvector-columns-and-triggers?utm_source=postgresweekly&utm_medium=email) Thoughtbot#tutorial [par_psql: Parallel psql](https://github.com/gbb/par_psql/?utm_source=postgresweekly&utm_medium=email)Parallel ‘psql’. Run parallel queries inline in PostgreSQL’s psql tool. Useful for ‘slightly big data’, GIS. Graeme B Bell#tools [Holycorn: PostgreSQL Multi-purpose Ruby Data Wrapper](https://github.com/franckverrot/holycorn?utm_source=postgresweekly&utm_medium=email)Holycorn makes it easy to implement a Foreign Data Wrapper for Postgres using Ruby. It’s built on top of mruby. Franck Verrot#code    

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