Re: Perfomance of IN-clause with many elements and possible solutions

Dmitry Lazurkin <dilaz03@xxxxxxxxx> · Mon, 31 Jul 2017 22:29:01 +0300



    On 31.07.2017 19:42, Jeff Janes wrote:

    
        I think it is simply because no one has
          gotten around to implementing it that way.  When you can just
          write it as a values list instead, the incentive to make the
          regular in-list work better is not all that strong.
        

        Cheers,
        

        Jeff
      
    
    I see from explain that IN-clause uses just array with function ANY.
    I think for efficient implementation of this task I should implement
    new datatype "hashset". Am I wrong?