Re: indexes not working very well - Mailing list pgsql-general

Have you vacuum analyzed recently?

On Fri, 23 Mar 2001, Vilson farias wrote:

> Greetings,
>
>     I have a little problem here and need some help. I created a table where
> indexes are not working very well here. Please take a look at the code below
> (it's easier).
>
> bxs=# EXPLAIN SELECT hora_minuto FROM hora_minuto WHERE hora_minuto >
> '13:43:00';
> NOTICE:  QUERY PLAN:
>
> Seq Scan on hora_minuto  (cost=0.00..22.50 rows=333 width=8)
>
> EXPLAIN