Re: mis-estimation on data-warehouse aggregate creation

From: "F(dot) Senault" <fred(dot)letter(at)lacave(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: mis-estimation on data-warehouse aggregate creation
Date: 2004-11-16 10:55:59
Message-ID: 179155563.20041116115559@lacave.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Hervé Piedvache 2004-11-16 14:55:58 Tsearch2 really slower than ilike ?
Previous Message Kris Jurka 2004-11-16 09:10:17 mis-estimation on data-warehouse aggregate creation