From: | "Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Andreas Kretschmer <akretschmer(at)spamfence(dot)net>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: GIN index not used |
Date: | 2014-07-11 05:47:51 |
Message-ID: | D83E55F5F4D99B4A9B4C4E259E6227CD014C3306@AUX1EXC01.apac.experian.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Friday, July 11, 2014 3:43 PM
To: Huang, Suya
Cc: Andreas Kretschmer; pgsql-performance(at)postgresql(dot)org
Subject: Re: [PERFORM] GIN index not used
"Huang, Suya" <Suya(dot)Huang(at)au(dot)experian(dot)com> writes:
> Just found out something here
> http://www.postgresql.org/message-id/17021.1234474178@sss.pgh.pa.us
> So I dropped the index and recreate it by specifying: using gin(terms_ts gin__int_ops) and the index works.
Oh, you're using contrib/intarray?
Pursuant to the thread you mention above, we removed intarray's <@ and @> operators (commit 65e758a4d3) but then reverted that (commit 156475a589) because of backwards-compatibility worries. It doesn't look like anything got done about it since then. Perhaps the extension upgrade infrastructure would offer a solution now.
> My PG version is 9.3.4, none-default planner settings:
> enable_mergejoin = off
> enable_nestloop = off
[ raised eyebrow... ] It's pretty hard to see how those would be a good idea. Not all problems are best solved by hash joins.
regards, tom lane
About the contrib/intarray, do I have other choices not using that one?
About the join, yeah, in our testing for DW-like queries, hash join does improved the performance greatly...
Thanks,
Suya
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2014-07-11 08:22:07 | Re: 60 core performance with 9.3 |
Previous Message | Tom Lane | 2014-07-11 05:43:24 | Re: GIN index not used |