>
> The "IN(id_list)" portion is derived from a PHP-based recursive query
> and is passed into postgres based on user input--always a different
list
> of ID's. This seems to rule out a "JOIN" as an alternative query type
> which has been the general suggestion for avoiding the infamous "IN"
> issue which you are working on for 7.4.
>
You've seen several alternatives already, but my approach would be to
populate a temp table with the PHP-based recursive query id_list
(the COPY command offers a fast way to do so), and then JOIN on
that temp table.
Regards, Christoph