Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: [GENERAL] Perfomance of IN-clause with many elements and possible solutions
Date
Msg-id CAMkU=1wtsMaN-g_ytLGO+PMQO9TLgVhR2VaGtuZGCACFBg+84A@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Perfomance of IN-clause with many elements and possiblesolutions  (Dmitry Lazurkin <dilaz03@gmail.com>)
List pgsql-general
Tree view
On Tue, Jul 25, 2017 at 2:03 AM, Dmitry Lazurkin <dilaz03@gmail.com> wrote:
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?

Yes, it is probably too complex for a novice.  On the other hand, you might not be a novice anymore once you complete it!

Cheers,

Jeff

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [GENERAL] Perfomance of IN-clause with many elements and possible solutions
Next
From: Ed Behn
Date:
Subject: [GENERAL] Partitioned TEMP tables