| From: | pgsql(at)mohawksoft(dot)com |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql(at)mohawksoft(dot)com, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Query optimizer 8.0.1 (and 8.0) |
| Date: | 2005-02-05 12:29:33 |
| Message-ID: | 16560.24.91.171.78.1107606573.squirrel@mail.mohawksoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> pgsql(at)mohawksoft(dot)com writes:
>> -> Index Scan using rt1_zipr, rt1_zipl on rt1 (cost=0.00..121893.93
>> rows=30835 width=302)
>> Index Cond: ((zipr = 2186) OR (zipl = 2186))
>
>> zipl | 925 |
>> zipr | 899 |
>
> Those n_distinct values for zipl and zipr seem aberrant --- too low
> compared to the estimated rowcount you're showing. What are the
> true figures? Also, how about some EXPLAIN ANALYZEs and not just
> EXPLAINs?
>
>
^
tiger=# select count(distinct(zipr)), count(distinct(zipl)) from rt1 ;
count | count
-------+-------
35133 | 35393
(1 row)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-05 16:43:46 | Re: libpq API incompatibility between 7.4 and 8.0 |
| Previous Message | Marc G. Fournier | 2005-02-05 06:37:39 | Re: Patch Count? |