Re: [PERFORM] Incorrect row estimates in plan?

2007-09-26 Thread pgdba
Tom Lane-2 wrote: > > pgdba <[EMAIL PROTECTED]> writes: >> Tom Lane-2 wrote: >> -> Bitmap Index Scan on slog_gri_idx >> (cost=0.00..82.26 >> rows=2870 width=0) (actual time=41.306..41.306 rows=83538 loops=1) >> Index Cond: ((gid = 1) AND (r

Re: [PERFORM] Incorrect row estimates in plan?

2007-09-26 Thread pgdba
Hi Tom, Tom Lane-2 wrote: > > pgdba <[EMAIL PROTECTED]> writes: >> -> Bitmap Heap Scan on slog (cost=82.98..6434.62 rows=2870 >> width=61) (actual time=50.235..1237.948 rows=83538 loops=1) >> Recheck Cond: ((gid = 1)

[PERFORM] Incorrect row estimates in plan?

2007-09-26 Thread pgdba
Hi, I am having some trouble understanding a plan and was wondering if anyone could guide me. The query in question here seems to be showing some incorrect row counts. I have vacuumed and analyzed the table, but the estimate versus the actual total seems to be way out (est 2870 vs actual 85k). Per