Tuesday, November 16, 2004, 10:10:17 AM, you wrote:
> HashAggregate (cost=32869.33..32869.34 rows=1 width=36)
^
> (actual time=475182.855..475188.304 rows=911 loops=1)
^^^
> -> Nested Loop (cost=377.07..32869.32 rows=1 width=36)
^
> (actual time=130.179..464299.167 rows=1232140 loops=1)
^^^^^^^
Let me guess... You've never run "analyze" on your tables ?
Fred
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
