Re: mis-estimation on data-warehouse aggregate creation

From: Kris Jurka <books(at)ejurka(dot)com>
To: "F(dot) Senault" <fred(dot)letter(at)lacave(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: mis-estimation on data-warehouse aggregate creation
Date: 2004-11-16 19:49:31
Message-ID: Pine.BSO.4.56.0411161445450.14852@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, 16 Nov 2004, F. Senault wrote:

> Let me guess... You've never run "analyze" on your tables ?
>

No, I have. I mentioned that I did in my email, but you can also tell by
the exactly correct guesses for some other plan steps:

-> Seq Scan on period (cost=0.00..90.88 rows=3288 width=54) (actual time=0.118..12.126 rows=3288 loops=1)

Kris Jurka

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Alexandre Leclerc 2004-11-16 21:11:30 nuderstanding 'explain analyse'
Previous Message J. Andrew Rogers 2004-11-16 19:43:38 Re: Insertion puzzles