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

Postgres Weekly Issue 79 - October 29, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/79)**Postgres Weekly****Issue 79**
October 29, 2014[ToroDB: A JSON-based Document Database Built on Top of Postgres](https://github.com/torodb/torodb?files=1?utm_source=postgresweekly&utm_medium=email)ToroDB database takes an interesting approach to bridging NoSQL and SQL by supporting the Mongo wire protocol directly while storing data in Postgres._ToroDB_[Adventures in Searching with Postgres: Part 1](http://blog.carbonfive.com/2014/10/28/adventures-in-searching-with-postgres-part-1/?utm_source=postgresweekly&utm_medium=email)Postgres is very capable at searching through text, preventing the need to roll a specialized solution in many cases. Here’s the first of a multipart series of diving into working with full text search in PG._Matt Wean_[Tuning for Performance in Production – The DBA Role](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafZAAQ=CP6PerfT?utm_source=postgresweekly&utm_medium=email)Over time, conditions change including data growth, usage patterns, and the amount of resources available to the database. Periodic tuning is the Postgres DBAs role to ensure that things continue to run smoothly. [Learn how to optimize performance](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafZAAQ&ls=CP6PerfB) or get help with a [database check up.](http://www.enterprisedb.com/ahc&ls=CP6Perf)_EnterpriseDBSponsored_[![\](http://s3.amazonaws.com/nlga/uploads/item/image/26807/i.png)](http://www.enterprisedb.com/store/products/dba-training/01t50000001uafZAAQ=CP6PerfT?utm_source=postgresweekly&utm_medium=email)[Make A Logical Receiver Behave As A Synchronous Standby](http://michael.otacoo.com/postgresql-2/logical-receiver-synchronous-standby/?utm_source=postgresweekly&utm_medium=email)The logical decoding improvements lay a great foundation for the future of Postgres. Yet there’s not nearly enough detail on how you take advantage, here’s a dive into make it work as a synchronous replica._Michael Paquier_[Sharing Code and Experiences](http://www.slideshare.net/fabriziomello/sharing-code-and-experiences?utm_source=postgresweekly&utm_medium=email)A Google Summer of Code student presents a great tale of their experiences, including some of what they worked on relating to the Write-Ahead-Log in Postgres._Fabrizio Mello_[Why The Older-Than-Dirt Postgres Database Is Hot With Hipsters And Oldsters Alike](http://readwrite.com/2014/10/23/postgres-cool-and-getting-cooler?utm_source=postgresweekly&utm_medium=email)Postgres is continuing to pick up steam in [mainstream media](http://www.theregister.co.uk/2014/05/16/postgresql_nosql_conversion/) and for good reason, here’s yet another look on why the long reliable database is growing in popularity._Read Write_[Optimizing Your psql](https://www.periscope.io/blog/optimizing-your-psql.html?utm_source=postgresweekly&utm_medium=email)Adding to the [number](http://www.craigkerstiens.com/2013/02/13/How-I-Work-With-Postgres/) of [recent](http://robots.thoughtbot.com/improving-the-command-line-postgres-experience) articles on how to better use psql as an editor, here’s a great one with many tips for customization._Periscope_[Renewed Life for STI with the PostgreSQL JSON Type](https://netguru.co/blog/renewed-life-for-sti-with-postgresql-json-type?utm_source=postgresweekly&utm_medium=email)Table inheritance has long existed within Postgres, but not always had the same value. Here’s a fresh look at how you can take advantage._Szymon Frącczak_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|*)