--- title: "This Week's PostgreSQL News (#186)" publication: "Postgres Weekly" issue: 186 published_at: "2016-12-14" canonical_url: "https://postgresweekly.com/issues/186" --- Postgres Weekly 186 . [Read this on the Web](http://postgresweekly.com/issues/186) [Postgres Weekly](http://postgresweekly.com) Issue 186 — December 14, 2016 Next week we'll be doing a bumper round up of the best Postgres stories and news from the whole of 2016 - look out for it next Wednesday! :-) If you have anything you want to nominate or remind us of, just reply to this email. [A Few Postgres Essentials](https://blog.heroku.com/postgres-essentials?utm_source=postgresweekly&utm_medium=email)A few brief tips to help you get the most out of Postgres, including using a connection pooler and tracking your most expensive queries. Heroku [PostgreSQL 10's Built-In Partitioning](https://www.keithf4.com/postgresql-10-built-in-partitioning/?utm_source=postgresweekly&utm_medium=email)A look at a recent commit to the future version of Postgres that implements table partitioning. Keith Fiske#news [Trying Out Bloom Indexes in Postgres](http://www.cybertec.at/2016/12/trying-out-postgres-bloom-indexes/?utm_source=postgresweekly&utm_medium=email)Bloom filters are space-efficient probabilistic data structures that work around hashing data into bitfields. This post tests outs Postgres’ support for them as indexes. Kaarel Moppel#tutorial [Square Root Staffing Law Workbook](https://www.vividcortex.com/resources/square-root-staffing-law-workbook?utm_campaign=Postgres%20Weekly&utm_source=ppc)This free Excel workbook uses the square root staffing law to estimate the amount of capacity users need to provision to provide uniform quality of service at a higher load than their systems currently handle. [Download now](https://www.vividcortex.com/resources/square-root-staffing-law-workbook?utm_campaign=Postgres%20Weekly&utm_source=ppc). VividCortex#sponsored — [![\](https://copm.s3.amazonaws.com/3441ed19.png)](https://www.vividcortex.com/resources/square-root-staffing-law-workbook?utm_campaign=Postgres%20Weekly&utm_source=ppc) [A Call for Papers for PGCon 2017 (Ottawa, Canada - May 23-26)](http://www.pgcon.org/2017/papers.php?utm_source=postgresweekly&utm_medium=email)Proposals due by January 19. PGCon#news [The PostgreSQL License - What Does It Mean For Your Business?](http://blog.2ndquadrant.com/the-postgresql-license-what-does-it-mean-for-my-business/?utm_source=postgresweekly&utm_medium=email)All good news - it’s free, unlimited, with no catches. Umair Shahid#opinion [Zero Downtime Migrations with ActiveRecord and PostgreSQL](https://tech.lendinghome.com/zero-downtime-migrations-with-activerecord-and-postgresql-b3aca53ffbe6?utm_source=postgresweekly&utm_medium=email) Sean Huber#tutorial [Improving Search Speed with Trigram Indexes](https://sweetcode.io/fast-search-using-postgresql-trigram-indexes/?utm_source=postgresweekly&utm_medium=email)How Trigram indexes work and how they can be used to speed up queries that use LIKE conditions. Yorick Peterse#tutorial [pg_probackup: Backup and Recovery Manager for Postgres](https://github.com/postgrespro/pg_probackup/blob/ptrack/doc/pg_probackup.md?utm_source=postgresweekly&utm_medium=email) Postgres Professional#tools [PG Transform: Tools for Comparing and Modifying Databases at Scale](https://github.com/facetoe/pgtransform?utm_source=postgresweekly&utm_medium=email)Schema comparisons and transformations. Written in Python. facetoe#tools [Don't Get Frustrated - Get Hired](http://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_campaign=q4-16-postgresweekly)Sick of pushy recruiters, and dead end interviews? Try Hired to hear from top tier companies, and only talk to relevant companies. Hired#sponsored [A Visualization of pg_catalog Table Relationships](https://joelonsql.com/2016/12/10/pg_catalog-visualized/?utm_source=postgresweekly&utm_medium=email) Joel on SQL Postgres Weekly is curated by [Craig Kerstiens](https://twitter.com/craigkerstiens) [Read this issue on the Web](http://postgresweekly.com/issues/186) [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