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

Postgres Weekly Issue 65 - July 23, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/65)**Postgres Weekly****Issue 65**
July 23, 2014[Caching Expensive Queries with Materialized Views in PostgreSQL](http://www.csinaction.com/2014/07/21/caching-expensive-queries-with-materialized-views-in-postgresql/?utm_source=postgresweekly&utm_medium=email)Have a variety of long running queries that you need to access or report on more quickly? Materialized views can help in periodically refreshing the results. They’re available in 9.3 and get even better in 9.4._Christoph Schiessl_[Amazon RDS PostgreSQL Update](https://aws.amazon.com/blogs/aws/rds-postgres-sla/?utm_source=postgresweekly&utm_medium=email)Amazon’s RDS for Postgres is now out of public beta and generally available, along with SLAs. Take a look here for some of the people taking advantage as well as details around their SLA._Amazon_[Postgres 9.5 feature highlight: IMPORT FOREIGN SCHEMA](http://michael.otacoo.com/postgresql-2/postgres-9-5-feature-highlight-import-foreign-schema/?utm_source=postgresweekly&utm_medium=email)Foreign tables are incredibly powerful within Postgres. Though even in Postgres 9.3 with the Postgres FDW there have been some rough usability edges. Now in 9.5 (no not 9.4), there’s some great utility functions to make listing and importing foreign tables and schemas easier._Michael Paquier_[Rails 4 and PostgreSQL Arrays](http://blog.plataformatec.com.br/2014/07/rails-4-and-postgresql-arrays/?utm_source=postgresweekly&utm_medium=email)Rails 4 included support for Postgres’ array fields. Bernardo shows off the basics of how they work._Bernardo Chaves_[Getting information about PostgreSQL SSL connections](http://blog.hagander.net/archives/220-Getting-information-about-PostgreSQL-SSL-connections.html?utm_source=postgresweekly&utm_medium=email)Postgres has a variety of methods/options for how it can connect via SSL or not. While you can set certain policies the tools for then inspecting such are a little more rudimentary. Here’s a look at how you can explore further._Magnus Hagander_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|*)