| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Cc: | "Merlin Moncure" <merlin(dot)moncure(at)rcsonline(dot)com>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] bitmap scan issues 8.1 devel |
| Date: | 2005-08-17 21:33:15 |
| Message-ID: | 200508171433.15614.josh@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Merlin,
> -> Index Scan using product_structure_file_pkey on
> product_structure_file (cost=0.00..45805.23 rows=5722 width=288)
> (actual time=0.063..0.063 row
> s=1 loops=1)
It appears that your DB is estimating the number of rows returned much too
high (5722 instead of 1). Please raise the statistics on all columns to
about 500, analyze, and try your test again.
Thanks!
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-08-17 21:42:32 | Re: pthread stack on FreeBSD WAS: HEAD doesn't cope with libraries |
| Previous Message | Hannu Krosing | 2005-08-17 21:25:29 | Re: Missing CONCURRENT VACUUM (Was: Release notes for |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-08-17 21:54:36 | Re: [HACKERS] bitmap scan issues 8.1 devel |
| Previous Message | Merlin Moncure | 2005-08-17 20:40:34 | bitmap scan issues 8.1 devel |