Richard Huxton <dev@archonet.com> writes:
> Ketema wrote:
>> 5)Upgrade version of pg..currently is running 8.1.4
> Well every version gets better at planning, so it can't hurt.
+1 ... there are at least two things about this query that 8.2 could be
expected to be a great deal smarter about:
* mixed outer and inner joins
* something = ANY(array)
regards, tom lane
