All;
I have a client that wants to pass in as an IN clause a list of 7,000
values. The value set changes for each query and it ranges from 5,000 to
8,000 values.
The planning time is too long for the requirements. (250 - 300ms)
I got it to work in 50ms end to end by creating a temp table and doing a
copy from STDIN into the temp table
However this is a Java based app and getting it to do a copy is becoming
way more complex than it should be.
Anyone know of an alternate way to run a query where an id is one of X
values where X is a list of 5 - 8 thousand values that will not force
the planner to spend 200+ms prepping the plan?
Thanks in advance