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
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
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
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: