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

Postgres Weekly Issue 56 - May 1, 2014

[Archives](http://postgresweekly.com/issues) [Read this issue on the Web](http://postgresweekly.com/issues/56)**Postgres Weekly****Issue 56**
May 1, 2014[PostgreSQL: A Full Text Search Engine - Part 1](http://shisaa.jp/postset/postgresql-full-text-search-part-1.html?utm_source=postgresweekly&utm_medium=email)While you can do basic LIKE queries with Postgres, it can go much further when it comes to text search. Here’s a great overview of what features are available and what full text search in Postgres can do._Tim van der Linden_[Putting stats_temp_directory On A RAM Disk](http://hacksoclock.blogspot.ch/2014/04/putting-statstempdirectory-on-ramdisk.html?utm_source=postgresweekly&utm_medium=email)Postgres keeps a lot of various stats under the hood to help the planner work out how to best execute various queries. A little known trick is that you can set up the stats directory on to a RAM disk which has higher risk for loss but can significantly improve performance._Quinn Weaver_[Check out DB Weekly, our general database newsletter](http://dbweekly.com/issues/11?euid=*|UNIQID|*?utm_source=postgresweekly&utm_medium=email)DB Weekly is now a few months old and continues to coverage database trends and new releases and technologies each week. [Issue 11](http://dbweekly.com/issues/11?euid=*|UNIQID|*) looks at Crate Data, a new massively scalable data store, a video guide to DBAs, using normalization on SQL databases, and more. It's a great way to keep your finger on the pulse of database related developments._Cooper PressSponsored_[Migration of Postgres 9.2 to 9.3 with Homebrew and json_enhancements](http://www.peterbe.com/plog/pg-9.2-to-9.3-json_enhancement?utm_source=postgresweekly&utm_medium=email)In Postgres 9.2 we got JSON, but it still needed a lot to be more usable… Much of this came with the json_enhancements extension. But if upgrading from 9.2 to 9.3 there’s a few gotchas, just in case you’re in that boat here’s a few hints._Peter Bengtsson_[Postgres 9.4 Feature Highlight: REPLICA IDENTITY and Logical Replication](http://michael.otacoo.com/postgresql-2/postgres-9-4-feature-highlight-replica-identity-logical-replication/?utm_source=postgresweekly&utm_medium=email)Logical decoding is super powerful and a baseline for so many useful features that made it into 9.4. But what it really means and how you apply it still isn’t super clear, here’s a great first look at that._Michael Paquier_[Table Partitioning in PostgreSQL](http://informatics.unep-wcmc.org/post/84213191855/table-partitioning-in-postgresql?utm_source=postgresweekly&utm_medium=email)When tables pass millions of rows and you’re commonly reporting against them table partitioning may or may not give you some performance improvements. Here’s a basic guide on implementing it._Agnieszka Figiel_[UPSERTisms in Postgres, Part 2: Congestion](http://johtopg.blogspot.com/2014/04/upsertisms-in-postgres-part-2-congestion.html?utm_source=postgresweekly&utm_medium=email)Last week we highlighted the performance difference of implementing upsert a few different ways in Postgres. There was some response to it, and as a result here’s a followup of how the performance looks with concurrency._Marko Tiikkaja_[What Happens When Replacing A Function Used in an Index?](http://stackoverflow.com/questions/17601719/replace-function-used-in-index?utm_source=postgresweekly&utm_medium=email)Have a functional index in Postgres and want to change it? Depending on how you declare it changes what actually happens, here’s a clear example as well as an articulate answer to that._Stack Overflow_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|*)