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