Re: mis-estimation on data-warehouse aggregate creation

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