Re: GIN index not used - Mailing list pgsql-performance

From Emre Hasegeli
Subject Re: GIN index not used
Date
Msg-id 20140712083115.GA515@hasegeli-2.local
Whole thread Raw
In response to Re: GIN index not used  ("Huang, Suya" <Suya.Huang@au.experian.com>)
List pgsql-performance
> -----Original Message-----

It is hard to read your message.  You should indicate the quoted lines.
Please fix your email client.

> About the contrib/intarray, do I have other choices not using that one?

integer[] and contrib/intarray are two different data types.

> About the join, yeah, in our testing for DW-like queries, hash join does improved the performance greatly...

Then, it should be chosen by the planner.  I doubt it is the best
choice in all cases.  It is not advised to set these parameters
globally.


pgsql-performance by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: 60 core performance with 9.3
Next
From: "Magers, James"
Date:
Subject: Query Performance question