Re: [rt-users] PostgreSQL full-text index default type: GiST or GIN

2016-03-20 Thread k...@rice.edu
On Fri, Mar 18, 2016 at 12:21:13AM -0700, Alex Vandiver wrote: > On Thu, 17 Mar 2016 17:47:50 -0500 > Matt Zagrabelny wrote: > > > I am curious about the benchmarks you used to make this determination? > > > In particular, the GIN fastscan option can dramatically improve

[rt-users] PostgreSQL full-text index default type: GiST or GIN

2016-03-19 Thread k...@rice.edu
Hi, I am working on an upgrade from 3.8.x to 4.4.x and I noticed the following comment in the UPGRADING-4.2 file: The full-text indexing defaults for PostgreSQL have changed; GiST is now the suggested index, as well as storing data in a separate AttachmentsIndex table. Both changes improve

Re: [rt-users] PostgreSQL full-text index default type: GiST or GIN

2016-03-19 Thread Matt Zagrabelny
On Thu, Mar 17, 2016 at 3:29 PM, k...@rice.edu wrote: > Hi, > > I am working on an upgrade from 3.8.x to 4.4.x and I noticed the > following comment in the UPGRADING-4.2 file: > > The full-text indexing defaults for PostgreSQL have changed; GiST is now > the suggested index, as

Re: [rt-users] PostgreSQL full-text index default type: GiST or GIN

2016-03-19 Thread Alex Vandiver
On Thu, 17 Mar 2016 17:47:50 -0500 Matt Zagrabelny wrote: > > I am curious about the benchmarks you used to make this determination? > > In particular, the GIN fastscan option can dramatically improve search > > performance in versions 9.4 and above. Here is a nice discussion: