"Dave Golombek" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
