Postgres Pro
Downloads
Home   >   mailing lists

Re: Indexes not used - Mailing list pgsql-novice

From Tom Lane
Subject Re: Indexes not used
Date
Msg-id 15241.984689171@sss.pgh.pa.us
Whole thread Raw
In response to Indexes not used  ("D. Duccini" <duccini@backpack.com>)
Responses Re: Indexes not used
List pgsql-novice
Tree view 
"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

pgsql-novice by date:

Previous
From: "Jeff Williams"
Date:
Subject: PosgreSQL Windows install
Next
From: "D. Duccini"
Date:
Subject: Re: Indexes not used