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

Postgres Weekly 162   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 162 — June 22, 2016     

[PG Casts: Postgres Screencasts](https://www.pgcasts.com/?utm_source=postgresweekly&utm_medium=email)While we feature a lot of blog posts in Postgres Weekly, screencasts are more rare. If video is your preferred way of learning, this new collection may be just the thing. Jack Christensen#video [Timestamps and Time Zones in PostgreSQL](http://phili.pe/posts/timestamps-and-time-zones-in-postgresql/?utm_source=postgresweekly&utm_medium=email)Working with timestamps is often incredibly painful, often due to a mix of misunderstanding and other times due to lack of right tooling. This in depth post sets a good context and shows you the two options and when each makes sense in Postgres. Philipe Fatio#tutorial [PGDay UK 2016 (London, July 5)](http://www.pgconf.uk/?utm_source=postgresweekly&utm_medium=email)The UK’s only dedicated PostgresSQL annual user conference returns next month. PostgreSQL UK Usergroup#news [Postgres Vision 2016 Conference: Future of Enterprise Postgres. Open Source DM](http://www.enterprisedb.com/news-events/press-releases/postgres-vision-2016-conference-defines-future-enterprise-postgres-and-op?src=2016PGVisionPR)Postgres Vision focuses on current and future enterprise usage of Postgres. This event includes insights from technology and business luminaries, use cases, a look at the Postgres ecosystem, and long-range outlooks from analysts. Visit www.PostgresVision.com. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/1f560a39.png)](http://www.enterprisedb.com/news-events/press-releases/postgres-vision-2016-conference-defines-future-enterprise-postgres-and-op?src=2016PGVisionPR) [Faceted Search in the Single PostgreSQL Query](http://akorotkov.github.io/blog/2016/06/17/faceted-search/?utm_source=postgresweekly&utm_medium=email)If you have the need for faceted search in Postgres there’s a number of ways to implement it, this approach uses more of the modern functionality of Postgres: JSONB and GIN Indexes, and throws in full-text search for good measure. Alexander Korotkov#code [BRIN Indexes in PostgreSQL: Correlation, correlation, correlation](http://www.cybertec.at/2016/06/brin-indexes-correlation-correlation-correlation/?utm_source=postgresweekly&utm_medium=email)BRIN indexes have been introduced in PostgreSQL 9.5. While BRIN indexes are definitely a win, people tend to exagerate and use them ways too frequently, take a look at when they’re actually most helpful here. @postgresql_007 [Scaling Up Rails Apps with PostgreSQL Table Partitioning](https://karolgalanciak.com/blog/2016/06/12/scaling-up-rails-applications-with-postgresql-table-partitioning-part-2/?utm_source=postgresweekly&utm_medium=email)In the second part of this [two-part series](https://karolgalanciak.com/blog/2016/06/05/scaling-up-rails-applications-with-postgresql-table-partitioning-part-1/) the author takes a look at table partitioning in Postgres as a means for scaling your database load and how you integrate it directly to Rails. Karol Galanciak [PGConf Silicon Valley PostgreSQL Conference](http://www.pgconfsv.com/?utm_source=postgresweekly&utm_medium=email)PGConf Silicon Valley is one of a [few upcoming](http://2016.postgresopen.org/) Postgres conferences this fall. Early bird tickets are available as well as it’s CFP now being open, so grab your ticket or submit your talk today. pgconfsv.​com#news [Amazon RDS for Postgres Now Supports Cross-Region Read Replicas](https://aws.amazon.com/about-aws/whats-new/2016/06/amazon-rds-for-postgresql-now-supports-cross-region-read-replicas/?utm_source=postgresweekly&utm_medium=email) Amazon Web Services#news [pg_view: Detailed, Real-Time View of Your Postgres & System Metrics](https://github.com/zalando/pg_view?utm_source=postgresweekly&utm_medium=email)A command-line tool that offers a real-time view of your database and system metrics. Zalando SE#tools [pgCenter: A 'top'-Like PostgreSQL Statistics Viewer](https://github.com/lesovsky/pgcenter?utm_source=postgresweekly&utm_medium=email)Another command line interface to look at lots of different Postgres stats and information live. Lesovsky Alexey#tools [Apply to 100 top tech companies with 1 application](http://www.indeed.com/prime?kw=postgresweekly&sid=xp_cooperpress_job)Indeed Prime connects top tech talent with top tech companies in the US. Companies compete to hire developers on Indeed Prime. 100% free for job seekers. Land a job and get $5k from Indeed Prime. Indeed Prime#job    

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