Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51933=pgsql-performance-ar@postgresql.org>)
 id 1X5siO-0007HR-1P
 for pgsql-performance@arkaria.postgresql.org; Sat, 12 Jul 2014 08:31:28 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M51933=pgsql-performance-ar@postgresql.org>)
 id 1X5siN-0004I5-EJ
 for pgsql-performance@arkaria.postgresql.org; Sat, 12 Jul 2014 08:31:27 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <emre@hasegeli.com>) id 1X5siM-0004Hs-0w
 for pgsql-performance@postgresql.org; Sat, 12 Jul 2014 08:31:26 +0000
Received: from mail-wi0-x22e.google.com ([2a00:1450:400c:c05::22e])
 by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256)
 (Exim 4.80) (envelope-from <emre@hasegeli.com>) id 1X5siI-00043I-6K
 for pgsql-performance@postgresql.org; Sat, 12 Jul 2014 08:31:23 +0000
Received: by mail-wi0-f174.google.com with SMTP id d1so315500wiv.13
 for <pgsql-performance@postgresql.org>; Sat, 12 Jul 2014 01:31:19 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hasegeli.com;
 s=google;
 h=date:from:to:cc:subject:message-id:references:mime-version
 :content-type:content-disposition:in-reply-to:user-agent;
 bh=7Cqb9TG1mLOQYputhmeS3c/VEEbbwLJxxtfJcBkIkZM=;
 b=RS87AC3+xvUUw90C0Le/WYDtQRcxIsBV3nxGZ6b0HWq6qGKEvUhYsY5CmIGnjdgZGP
 VoL9d8jz5b8ZJ/xTAdrWuALEH6DeRFU6OSro1aLTbMYFctlr3Cd8B0waXlxj2kTdTfH0
 2RrwliMqbzgaDgcbgIm5/zzdsYaSEY5lvJ+PU=
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
 d=1e100.net; s=20130820;
 h=x-gm-message-state:date:from:to:cc:subject:message-id:references
 :mime-version:content-type:content-disposition:in-reply-to
 :user-agent;
 bh=7Cqb9TG1mLOQYputhmeS3c/VEEbbwLJxxtfJcBkIkZM=;
 b=DBqcAn7IJdLPCR0dAKKoIqrXZN70zPGDbsHqZmi7HRVh0jkpJzv2CH/HWx9eoG8Ye6
 epX1Uh3Zzljgx78SnqKB4jAIhILGdIPOiUG4zdMwFQ6cPdlTZ2LESQbl3+zIJ1RLZsfp
 oKHaZReB6TKDxlP6QhoNfJqHpY+BnB4NikSZ3U9F8aNH/IDxO6IDlGot03tuVhYs2sWk
 hHfNJf6Hxq+Z/0D8o3+Ud3IWTbhIJX8SUE8Hbd8rg0LutwIV0fM5e5S6aKKuiqIKvusg
 EjMAmf1nhZvwWXIKi51soQIvYx9c5046Bm6VstonVpWfmtPuLBenNCsjYlvAcH9MByRb
 xyow==
X-Gm-Message-State: 
 ALoCoQnet0VriAzjk8Bp/7k1If/UYNj38xRcpmeL74JYoXJxqxkOZWV7Qbnh0oHW2EVtxNEXsZcT
X-Received: by 10.180.108.1 with SMTP id hg1mr11693122wib.25.1405153879409;
 Sat, 12 Jul 2014 01:31:19 -0700 (PDT)
Received: from hasegeli-2.local ([24.133.146.176])
 by mx.google.com with ESMTPSA id d12sm10420311wjx.0.2014.07.12.01.31.17
 for <multiple recipients>
 (version=TLSv1 cipher=ECDHE-RSA-RC4-SHA bits=128/128);
 Sat, 12 Jul 2014 01:31:18 -0700 (PDT)
Date: Sat, 12 Jul 2014 11:31:15 +0300
From: Emre Hasegeli <emre@hasegeli.com>
To: "Huang, Suya" <Suya.Huang@au.experian.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
 Andreas Kretschmer <akretschmer@spamfence.net>,
 "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Subject: Re: GIN index not used
Message-ID: <20140712083115.GA515@hasegeli-2.local>
References: 
 <D83E55F5F4D99B4A9B4C4E259E6227CD014C3263@AUX1EXC01.apac.experian.local>
 <20140711044452.GA7390@tux> <20680.1405054574@sss.pgh.pa.us>
 <D83E55F5F4D99B4A9B4C4E259E6227CD014C32C9@AUX1EXC01.apac.experian.local>
 <21821.1405057404@sss.pgh.pa.us>
 <D83E55F5F4D99B4A9B4C4E259E6227CD014C3306@AUX1EXC01.apac.experian.local>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: 
 <D83E55F5F4D99B4A9B4C4E259E6227CD014C3306@AUX1EXC01.apac.experian.local>
User-Agent: Mutt/1.5.21 (2010-09-15)
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance