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