On Mon, Feb 22, 2010 at 12:10 PM, Tom Lane wrote:
>> I've left it running over night. By
>> comparison, a "select * from metarelcloud_transactionlog order by
>> transactionid" takes on the order of seconds/minutes (at least in
>> MySQL).
>
> That's got approximately nothing to do with this query.
Yang Zhang writes:
> Hi, I have the given tables and query, but I'm confused why the cost
> of the query is so high.
The reason the estimated cost is so high is that the estimated number of
rows out of the join is enormous. It's going to take awhile. One
question worth asking is what you've got
