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

Postgres Weekly Issue 85 - December 10, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/85)**Postgres Weekly****Issue 85**
December 10, 2014Please note that next week's issue may be delayed by a day so that we can bring you the Postgres 9.4 release as soon as it happens (unless the schedule changes).[Speeding Up PostgreSQL With Partial Indexes](http://blog.heapanalytics.com/speeding-up-postgresql-queries-with-partial-indexes/?utm_source=postgresweekly&utm_medium=email)Exclusively first to PG Weekly: the second post from [Heap](http://www.heapanalytics.com/) in as many weeks. This one digs into something that’s existed for a bit in Postgres but still seldom used: indexing just a portion of your data. _(Ignore the 2012 date on the article, it's wrong.)__Heap_[Postgres 9.4.0 To Be Released December 18th](http://www.postgresql.org/message-id/26295.1417708564@sss.pgh.pa.us?utm_source=postgresweekly&utm_medium=email)Postgres 9.4 has a release date, and no it’s not here yet, but we’re just over a week away until we can all start to take advantage of JSONB and all the other greatness in this new release._Tom Lane_[pg_shard: A PostgreSQL Extension to Scale Out Real-Time Reads and Writes](https://github.com/citusdata/pg_shard?utm_source=postgresweekly&utm_medium=email)Want to shard your data and not have to think about all the hard parts of it? Here’s a PostgreSQL extension to scale out real-time reads and writes from right in your DB._Citus Data_[Immersive JavaScript Courses Begin Feb 2 and Mar 23](http://www.hackreactor.com/?utm_source=coopermedia=dec10postgresweeklyexclusive=general?utm_source=postgresweekly&utm_medium=email)While our Feb 2 onsite course is full, we're still accepting applications for its online counterpart as well as our Mar 23 onsite and online courses. Apply today and become a mid-to-senior level developer in 12 weeks._Hack ReactorSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/23801/t.png)](http://www.hackreactor.com/?utm_source=coopermedia=dec10postgresweeklyexclusive=general?utm_source=postgresweekly&utm_medium=email)[Will Paginate in Half the Time](http://tech.patientslikeme.com/2011/04/06/will-paginate-in-half-the-time.html?utm_source=postgresweekly&utm_medium=email)Pagination is a common task in many applications but it’s not always fast. Fortunately [CTEs](http://www.craigkerstiens.com/2013/11/18/best-postgres-feature-youre-not-using/) can make your life easier and your queries faster._Jeff Dwyer_[Postgres 9.4: The Ideal Domain-Driven Design Aggregate Store?](https://vaughnvernon.co/?p=942?utm_source=postgresweekly&utm_medium=email)An interesting thought piece that talks about what Postgres 9.4, and in particular JSONB, enables around a fundamentally new type of datastore working with both JSON, the relational DB, and aggregates._Vaughn Vernon_[postgresql-pretty-table: A Script to Make Pretty HTML Tables from psql](https://github.com/ustun/postgresql-pretty-table?utm_source=postgresweekly&utm_medium=email)A handy but small script to make pretty html tables from your queries directly out of psql._Ustun Ozgur_[Multicorn based PostgreSQL Foreign Data Wrapper for RethinkDB](https://github.com/wilsonrmsorg/rethinkdb-multicorn-postgresql-fdw?utm_source=postgresweekly&utm_medium=email)Want to query everything not in Postgres from Postgres? Well we’re not at “everything”, but you can for most things with Foreign Data Wrappers, and RethinkDB is now part of that list._Wilson RMS_[What's This pg_shard Thing?](http://www.databasesoup.com/2014/12/whats-this-pgshard-thing.html?utm_source=postgresweekly&utm_medium=email)pg_shard is less than a week old but we’re already getting some clear write-ups of what it can and can’t do. Here’s a great one from a Postgres core community member._Josh Berkus_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|*)