Re: [GENERAL] Perfomance of IN-clause with many elements and possiblesolutions - Mailing list pgsql-general

From Dmitry Lazurkin
Subject Re: [GENERAL] Perfomance of IN-clause with many elements and possiblesolutions
Date
Msg-id fb754c1f-4541-243f-5ef0-93d159d65e92@gmail.com
Whole thread Raw
In response to Re: [GENERAL] Perfomance of IN-clause with many elements and possible solutions  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: [GENERAL] Perfomance of IN-clause with many elements and possible solutions
List pgsql-general
On 25.07.2017 05:50, Jeff Janes wrote:
> It isn't either-or.  It is the processing of millions of rows over the
> large in-list which is taking the time. Processing an in-list as a
> hash table would be great, but no one has gotten around to it
> implementing it yet.  Maybe Dmitry will be the one to do that.

Thanks. Yes, I want. But... Is this task too complex for novice?


pgsql-general by date:

Previous
From: Amee Sankhesara - Quipment India
Date:
Subject: [GENERAL] Major Version Upgradation from 9.4 to 9.6 in Replication Environment
Next
From: Adam Šlachta
Date:
Subject: [GENERAL] How to get transaction started always in WRITE mode.