"Dave Golombek" <daveg@blackducksoftware.com> writes:
> Ah, I forgot to try the index on the base table using 8.2, which does indeed
> solve the problem. It unfortunately doesn't help with 8.1.4, which we have
> in the field; any thoughts on workarounds for older versions or should I
> just use a function until we can upgrade everywhere? We have 150 million
> rows spread across 16 child tables, which should help cost estimation.
Sorry, 8.1 is just not capable of generating that type of plan --- it
won't push join clauses down into an Append.
regards, tom lane