Re: 8.4.7, incorrect estimate

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Wayne Conrad" <wayne(at)databill(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: 8.4.7, incorrect estimate
Date: 2011-04-29 19:33:39
Message-ID: 4DBACC43020000250003D070@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Wayne Conrad <wayne(at)databill(dot)com> wrote:

> -> Seq Scan on temp_doc_ids
> (cost=0.00..23.48 rows=1310 width=32)
> (actual time=0.005..0.005 rows=5 loops=1)

Also, make sure that you run ANALYZE against your temp table right
before running your query.

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Andy Colson 2011-04-29 20:23:25 Re: Performance
Previous Message Joachim Worringen 2011-04-29 19:15:33 Re: FUSION-IO io cards