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

From: Dmitry Lazurkin <dilaz03(at)gmail(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Bill Moran <wmoran(at)potentialtech(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Perfomance of IN-clause with many elements and possible solutions
Date: 2017-07-25 09:03:01
Message-ID: fb754c1f-4541-243f-5ef0-93d159d65e92@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Šlachta 2017-07-25 09:32:35 How to get transaction started always in WRITE mode.
Previous Message Amee Sankhesara - Quipment India 2017-07-25 06:33:12 Major Version Upgradation from 9.4 to 9.6 in Replication Environment