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

Postgres Weekly 104   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 104 — May 6, 2015     

[Materialized View Strategies Using PostgreSQL](http://hashrocket.com/blog/posts/materialized-view-strategies-using-postgresql?utm_source=postgresweekly&utm_medium=email)Views are a way to represent the results of a query as a table, and materialized views actually create that data versus just running a query each time. They’re a great way to cache aggregate data when running an expensive query over time. Jack Christensen [Compressing PostgreSQL JSONB data 12x using cstore_fdw](https://www.citusdata.com/blog/14-marco/156-compressing-jsonb-using-cstore-fdw?utm_source=postgresweekly&utm_medium=email)Citus Data’s cstore FDW offers a promising option for a columnar store in Postgres. Marco highlights some of the benefits, showing the storage space on disk of the powerful new JSONB datatype. Marco Slot [Barman 1.4.1 Released](http://www.postgresql.org/about/news/1583/?utm_source=postgresweekly&utm_medium=email)Barman (Backup and Recovery Manager) is an open source administration tool for disaster recovery of PostgreSQL servers written in Python. Postgresql.​org [Are You Really Ready to Deploy?](http://www.enterprisedb.com/postgres-plus-edb-blog/debra-brucato/tales-trenches-postgres-support-calls?utm_source=cooperpress&utm_medium=nl&utm_campaign=tdeploy)The vast majority of questions arise during the deployment and maintenance phases of Postgres projects, not during development or POC. And with good reason - Postgres is an easy database to work with. But planning ahead for deployment and taking care of ongoing maintenance are the keys to success. Get prepared by reading [Tales from The Trenches](http://www.enterprisedb.com/postgres-plus-edb-blog/debra-brucato/tales-trenches-postgres-support-calls?utm_source=cooperpress=nl=bdeploy) or improve performance with an [Architectural Health Check](http://www.enterprisedb.com/AHC?utm_source=cooperpress=nl=bahc). EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/ad3fc157.jpg)](http://www.enterprisedb.com/postgres-plus-edb-blog/debra-brucato/tales-trenches-postgres-support-calls?utm_source=cooperpress&utm_medium=nl&utm_campaign=tdeploy) [Bottled Water: Real-time Integration of PostgreSQL and Kafka](http://blog.confluent.io/2015/04/23/bottled-water-real-time-integration-of-postgresql-and-kafka/?utm_source=postgresweekly&utm_medium=email)Postgres is great as a reliable persistent store for data, but often in real-time/event focused systems people look to other options. But here’s a look at what integrating and blending those worlds together could look like through streaming Postgres WAL to Kafka. Confluent [Simplify: Move Code Into Database Functions](https://sivers.org/pg?utm_source=postgresweekly&utm_medium=email)A provoking and clearly thought out piece around the idea of moving much more code and logic directly into your database (something many DBAs will be nodding their heads about). Derek Sivers [Postgres Never Ceases to Amaze Me](https://shawtyds.wordpress.com/2015/04/08/postgres-never-ceases-to-amaze-me/?utm_source=postgresweekly&utm_medium=email)For many, Postgres is just the database behind their ORM, for others it becomes a powerful and unique tool, such as in this author’s situation when working with in the context of a GIS (geographic information system). Peter Shaw [Postgres JSON Column Type in Rails 4](http://blog.chadwilken.com/json-with-postgres-in-rails/?utm_source=postgresweekly&utm_medium=email)The JSON and JSONB datatypes are wonderful, but most people building apps aren’t writing raw SQL. Instead, you’re going through the ORM of whatever your chosen framework is, and if it hasn’t adapted yet you’re out of luck. Fortunately Rails 4 works great out of the box. Chad Wilken    

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