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

Postgres Weekly 117   . 

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

[Postgres Weekly](http://postgresweekly.com) Issue 117 — August 5, 2015     

[Postgres Guide](http://www.postgresguide.com/?utm_source=postgresweekly&utm_medium=email)Postgres Guide is a guide I’ve maintained for a few years, meant to be a getting started for Postgres. It recently got a bit make over, take a look and if you want to help contributions are always welcome. Craig Kerstiens [Analyzing Extreme Distributions in PostgreSQL](https://tech.zalando.com/blog/analyzing-extreme-distributions-in-postgresql/?utm_source=postgresweekly&utm_medium=email)Postgres keeps a lot of stats about your data and your queries and these are easy to access yourself with a little know how. This is a great guide to understanding more of your Postgres stats. Stefan Litsche [Live Postgres Training with Free Certification](http://www.enterprisedb.com/store/products/dba-training/01t500000031mz3AAA?utm_source=cooperpress=nl=t117)Here’s a special deal on the popular foundational course for Postgres Administration. This is beneficial if you are new to Postgres but have used other databases, or if you want to refresh your knowledge and get a BONUS 9.4 certification free. Use promo code PGW-WEB-10 for 10% off. EnterpriseDB#sponsored[![\](https://copm.s3.amazonaws.com/1ab33624.png)](http://www.enterprisedb.com/store/products/dba-training/01t500000031mz3AAA?utm_source=cooperpress=nl=t117) [Making Postgres Bloom](http://www.pipelinedb.com/blog/making-postgres-bloom?utm_source=postgresweekly&utm_medium=email)Bloom filters are a probabilistic data structure that are space efficient for membership queries in a set of data (at the cost of false positives).Here’s a great walk through of recreating their functionality in Postgres. Usman Masood [Announcing pg_shard 1.2](https://www.citusdata.com/blog/21-jason/185-announcing-pg-shard-1-2?utm_source=postgresweekly&utm_medium=email)pg_shard is one of the few options for ‘out of the box’ sharding with Postgres. It’s gotten some new updates to continue rounding out rough edges, so if you’re needing to shard, give it a look. Citus Data [About the PGConf Silicon Valley PostgreSQL Conference](http://www.pgconfsv.com/?utm_source=postgresweekly&utm_medium=email#!about/cjg9)There’s only a few key Postgres conferences each year, a newer one among those is PGConf Silicon Valley. Proving to have a great lineup from Postgres hackers and users, if you’re looking for a Postgres conference this is one to consider. PGConfSV [Postmortem for July 27 Outage of the Manta Service](https://www.joyent.com/blog/manta-postmortem-7-27-2015?utm_source=postgresweekly&utm_medium=email)For the second time in as many weeks we’ve got a post talking about the issues of transaction wrap-around in Postgres. If you’ve got a high throughput system, or appreciate interesting detailed postmortems, this is a good read. Joyent [Presenting JSONB Data As A Traditional Relation for Hibernate and JPAs](http://www.enterprisedb.com/postgres-plus-edb-blog/jamey-hanson/presenting-jsonb-data-traditional-relation-hibernate-and-jpas?utm_source=postgresweekly&utm_medium=email)Sure JSONB works well with many modern ORMs and frameworks such SQLAlchemy in Python or [even in Rails](http://nandovieira.com/using-postgresql-and-jsonb-with-ruby-on-rails), but it also can be a good solution with more enterprise architectures as shown here with Hibernate JPAs. EnterpriseDB [Full Stack Engineer at Namely (New York, NY)](https://jobs.lever.co/namely/b3b9894e-8eb0-4596-8c4f-7a93b7154467?utm_source=postgresweekly&utm_medium=email)Namely is an agile startup dedicated to building an end-to-end HR platform for businesses of all sizes. We’re looking for a skilled developer to contribute ideas, innovation, solutions and code to our product. Namely#job [Join The Top 3% of Freelance PostgreSQL Developers Worldwide](http://www.toptal.com/developers?utm_source=postgresweekly&utm_medium=email&utm_content=postgres_weekly&utm_campaign=top_3)Toptal is an exclusive network of elite freelance software engineers. Apply today to work with top clients, set your own rates, and collaborate with other top PostgreSQL developers. Toptal#job    

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