Thread: Update docs for GIN index improvements

Update docs for GIN index improvements

From
Bruce Momjian
Date:
We have made major improvements in GIN in the past few releases,
particularly 9.4, but the full text search docs recommending when to use
GIN and GiST indexes have not been updated.  This blog post empirically
shows many of the improvements:

    http://blog.pgaddict.com/posts/performance-since-postgresql-7-4-to-9-4-fulltext

I would like to apply the attached patch to 9.5 to recommend GIN indexes
for full text search, and remove mention of many old GIN limitations.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

Attachment

Re: Update docs for GIN index improvements

From
Bruce Momjian
Date:
On Sat, May 16, 2015 at 08:37:59AM -0400, Bruce Momjian wrote:
> We have made major improvements in GIN in the past few releases,
> particularly 9.4, but the full text search docs recommending when to use
> GIN and GiST indexes have not been updated.  This blog post empirically
> shows many of the improvements:
>
>     http://blog.pgaddict.com/posts/performance-since-postgresql-7-4-to-9-4-fulltext
>
> I would like to apply the attached patch to 9.5 to recommend GIN indexes
> for full text search, and remove mention of many old GIN limitations.

Done.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Roman grave inscription                             +