---
title: "This Week's PostgreSQL News (#78)"
publication: "Postgres Weekly"
issue: 78
published_at: "2014-10-21"
canonical_url: "https://postgresweekly.com/issues/78"
---

Postgres Weekly Issue 78 - October 21, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/78)**Postgres Weekly****Issue 78**
October 21, 2014[Multi-Table Full-text Search with Postgres (slide deck + video)](http://calebthompson.io/talks/search.html?utm_source=postgresweekly&utm_medium=email)Sometimes basic searching on a single column can work for you, but often you need something more powerful. Fortunately Postgres’ full text search can help, and here’s a great talk which shows how to make things work across tables._Caleb Thompson_[Solving Data “Variety” with Postgres’s NoSQL Extensions](http://java.dzone.com/articles/solving-data-variety?utm_source=postgresweekly&utm_medium=email)There’s been much talk about the upcoming Postgres 9.4 release. Though for all the talk there haven’t been enough walkthroughs of what flexibility in schema the new features will provide, at least until this one.[Monitoring Postgresql with a Background Worker](http://no0p.github.io/postgresql/2014/10/21/postgresql-monitoring-framework.html?utm_source=postgresweekly&utm_medium=email)While there are more and more options for monitoring Postgres, it’s still not a perfectly solved problem. Here’s a great post on monitoring it with background workers using two open source tools._Robert Berry_[Postgres Skills are in Demand - Add to your skill set and get certified](http://www.enterprisedb.com/products-services-training/training?utm_source=postgresweekly=email=training5?utm_source=postgresweekly&utm_medium=email)2000+ jobs are now posted each month listing Postgres skills – enhance your talents and get certified with expert training courses. The EDB certification program sets the global standard for Postgres professionals, and is definitive proof of your Postgres skills._EnterpriseDBSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/26807/i.png)](http://www.enterprisedb.com/products-services-training/training?utm_source=postgresweekly=email=training5?utm_source=postgresweekly&utm_medium=email)[Pagination Done the PostgreSQL Way](http://leopard.in.ua/2014/10/11/postgresql-paginattion/?utm_source=postgresweekly&utm_medium=email)Some examples of performing pagination with SQL on Postgres, working from a simple but inefficient example through to an interesting ‘seek’ based approach._Alexey Vasiliev_[How to Start using Arrays in Rails with PostgreSQL](http://blog.arkency.com/2014/10/how-to-start-using-arrays-in-rails-with-postgresql/?utm_source=postgresweekly&utm_medium=email)Arrays are super powerful and convenient for when you need them in Postgres. There’s often no good reason you shouldn’t use them when you want and your framework such as Rails shouldn’t limit you._Kamil Lelonek_[pgweb: Web-based PostgreSQL Database Browser](https://github.com/sosedoff/pgweb?utm_source=postgresweekly&utm_medium=email)Adding to the likes of [JackDB](https://www.jackdb.com), which is a SaaS offering, here’s a web-based browser for your Postgres database should you prefer something that’s not local._Dan Sosedoff_[Introducing Flexible Freeze](http://www.databasesoup.com/2014/10/introducing-flexible-freeze.html?utm_source=postgresweekly&utm_medium=email)Often times there’s a need to freeze tables when there’s a lull on your database. Now there’s a [project](https://github.com/pgexperts/flexible-freeze) focusing on just that, at this time as a simple easy to use script._Database Soup_[Quickly list missing foreign key indexes](https://tomafro.net/2009/09/quickly-list-missing-foreign-key-indexes?utm_source=postgresweekly&utm_medium=email)An older, but still handy, post which highlights how to discover which foreign keys have missing indexes on them within Rails._Tom Ward_[Postgres 9.5 Feature Highlight: Replication Slot Control with pg_receivexlog](http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-physical-slot-pg-receivexlog/?utm_source=postgresweekly&utm_medium=email)_Michael Paquier_Curated by [Craig Kerstiens](http://craigkerstiens.com/) and published by [Cooper Press](https://cooperpress.com/).
Want to sponsor an issue? See our [media kit.](https://cooperpress.com/mediakit2014q2.pdf)

 © 2017 Cooper Press Ltd. [Email policy](https://cooperpress.com/spam.html) [Privacy policy](https://cooperpress.com/privacy.html)
Office 30, Fairfield Enterprise Centre, Louth, LN11 0LS, UK[Update your email address](*|UPDATE_PROFILE|*)
or [unsubscribe here](*|UNSUB|*)