"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes: > The following query ran in a fraction of a second on 7.4.8: > ... > On 8.0.4, it runs for hours (stopped after two hours). Here's the plan:
Do you have the plan used by 7.4?
BTW, this is not really on-topic for pgsql-general; pgsql-perform would
be a more appropriate forum.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
