Optimization idea for long IN() lists

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: postgres performance list <pgsql-performance(at)postgresql(dot)org>
Subject: Optimization idea for long IN() lists
Date: 2014-08-08 19:15:36
Message-ID: 53E521D8.7090500@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Folks,

So one thing we tell users who have chronically long IN() lists is that
they should create a temporary table and join against that instead.
Other than not having the code, is there a reason why PostgreSQL
shouldn't do something like this behind the scenes, automatically?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Maxim Boguk 2014-08-09 04:22:00 Re: Optimization idea for long IN() lists
Previous Message Evgeniy Shishkin 2014-08-08 13:57:37 Re: two table join with order by on both tables attributes