Re: 8.4.7, incorrect estimate - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: 8.4.7, incorrect estimate
Date
Msg-id 4DBACC43020000250003D070@gw.wicourts.gov
Whole thread Raw
In response to 8.4.7, incorrect estimate  (Wayne Conrad <wayne@databill.com>)
Responses Re: 8.4.7, incorrect estimate  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Wayne Conrad <wayne@databill.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

pgsql-performance by date:

Previous
From: Joachim Worringen
Date:
Subject: Re: FUSION-IO io cards
Next
From: Andy Colson
Date:
Subject: Re: Performance