Re: GIN index not used

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux