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

Re: Indexes not used

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "D(dot) Duccini" <duccini(at)backpack(dot)com>
Cc: Pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Indexes not used
Date: 2001-03-15 20:46:11
Message-ID: 15241.984689171@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"D. Duccini" <duccini(at)backpack(dot)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

In response to

Responses

pgsql-novice by date

Next:From: D. DucciniDate: 2001-03-15 20:48:11
Subject: Re: Indexes not used
Previous:From: D. DucciniDate: 2001-03-15 20:42:04
Subject: Re: Indexes not used

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