Optimization idea for long IN() lists - Mailing list pgsql-performance

From Josh Berkus
Subject Optimization idea for long IN() lists
Date
Msg-id 53E521D8.7090500@agliodbs.com
Whole thread Raw
Responses Re: Optimization idea for long IN() lists
List 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


pgsql-performance by date:

Previous
From: Evgeniy Shishkin
Date:
Subject: Re: two table join with order by on both tables attributes
Next
From: Maxim Boguk
Date:
Subject: Re: Optimization idea for long IN() lists