Skip site navigation (1) Skip section navigation (2)

Re: Query optimizer 8.0.1 (and 8.0)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql(at)mohawksoft(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Query optimizer 8.0.1 (and 8.0)
Date: 2005-02-05 00:03:46
Message-ID: 18635.1107561826@sss.pgh.pa.us (view raw or flat)
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?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2005-02-05 01:05:15
Subject: Re: libpq API incompatibility between 7.4 and 8.0
Previous:From: pgsqlDate: 2005-02-04 23:50:30
Subject: Re: Query optimizer 8.0.1 (and 8.0)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group