"Julian Scarfe" <[EMAIL PROTECTED]> writes:
> From: "Tom Lane" <[EMAIL PROTECTED]>
>> The
>> problem you've got is that you need a nestloop-with-inner-indexscan
>> plan type, where the inner side is an Append group (that is, an
>> inheritance tree) --- and 8.1 doesn't know how to create such a plan
From: "Tom Lane" <[EMAIL PROTECTED]>
The
problem you've got is that you need a nestloop-with-inner-indexscan
plan type, where the inner side is an Append group (that is, an
inheritance tree) --- and 8.1 doesn't know how to create such a plan.
If you can update to 8.2 or later it should get bette
"Julian Scarfe" <[EMAIL PROTECTED]> writes:
>> Without the EXPLAIN ANALYZE output, nobody can say whether you have
>> interpreted your performance problem correctly or not.
> Fair enough, Tom.
Okay, so the "expensive function" isn't as expensive as all that ---
it seems to be adding only a few ms
Without the EXPLAIN ANALYZE output, nobody can say whether you have
interpreted your performance problem correctly or not.
Fair enough, Tom.
superclass = "geonode", subclass = "airport", expensive_function =
"gc_offroute".
For this test, some_table is also "airport".
There's also a coarse
