Postgres Pro
Downloads
Home   >   mailing lists

Re: mis-estimation on data-warehouse aggregate creation - Mailing list pgsql-performance

From F. Senault
Subject Re: mis-estimation on data-warehouse aggregate creation
Date
Msg-id 179155563.20041116115559@lacave.net
Whole thread Raw
In response to mis-estimation on data-warehouse aggregate creation  (Kris Jurka <books@ejurka.com>)
Responses Re: mis-estimation on data-warehouse aggregate creation
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Kris Jurka
Date:
Subject: mis-estimation on data-warehouse aggregate creation
Next
From: Hervé Piedvache
Date:
Subject: Tsearch2 really slower than ilike ?