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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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