Postgres Weekly Issue 56
May 1, 2014
PostgreSQL: A Full Text Search Engine - Part 1
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
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
DB Weekly is now a few months old and continues to coverage database trends and new releases and technologies each week. Issue 11 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 Press  Sponsored
Migration of Postgres 9.2 to 9.3 with Homebrew and json_enhancements
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
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
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
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?
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