Horton

Re: Indexes not used

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: "D. Duccini" <duccini@backpack.com>
Cc: Pgsql-novice <pgsql-novice@postgresql.org>
Date: 2001-03-15T20:46:11Z
Lists: pgsql-novice 
"D. Duccini" <duccini@backpack.com> writes:
> # select count(*) from radusage;
>  count  
> --------
>  573042
> (1 row)

In that case 5757 is definitely a default estimate (.01 is the default
selectivity IIRC).

> what is the analyze?  i've run vacuum several times

VACUUM ANALYZE

			regards, tom lane