[PERFORM] Optimization idea for long IN() lists

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

Re: [PERFORM] Optimization idea for long IN() lists

On Sat, Aug 9, 2014 at 5:15 AM, Josh Berkus j...@agliodbs.com wrote: 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