| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
| Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: 7.4beta2 vs 7.3.3 |
| Date: | 2003-09-19 02:59:42 |
| Message-ID: | 7882.1063940382@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Gaetano Mendola <mendola(at)bigfoot(dot)com> writes:
> The default_statistics_target was already 1000 for
> postgres7.4beta2 and after setting this value to 1000
> for postgres7.3.3 I had the same explain with the same
> expected row ( almost 400 ) and the almost the same time execution.
Hmph. Can you look into why the row count estimate is still off by 10x
with stats target 1000? Seems like there must be some odd skew in your
data statistics.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-09-19 03:20:37 | Re: osdl-dbt3 run results - puzzled by the execution plans |
| Previous Message | Tom Lane | 2003-09-19 02:50:27 | Re: Array Parameters on protocol 3.0 |