Hi,
I am using postgres 8.1.3 for this. If this has been dealt with later, please
disregard. And this is not a complaint or a request, I am just curious, so I
know how to best construct my queries.
There is a unique index mapping domains to domain_ids.
views_ts specifies a partitioned
Brian Herlihy [EMAIL PROTECTED] writes:
There is a unique index mapping domains to domain_ids.
...
The issue: the second query results in a lower cost estimate. I am wondering
why the second query plan was not chosen for the first query.
Well the unique index you mentioned is critical to
Brian Herlihy [EMAIL PROTECTED] writes:
The issue: the second query results in a lower cost estimate. I am wondering
why the second query plan was not chosen for the first query.
8.1 is incapable of pushing indexable join conditions down below an Append.
Try 8.2.