Re: indexes not working very well

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Vilson farias <vilson(dot)farias(at)digitro(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: indexes not working very well
Date: 2001-03-23 20:11:48
Message-ID: Pine.BSF.4.21.0103231209070.47309-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matt Friedman 2001-03-23 20:52:25 Re: Slow SELECT...IN statements
Previous Message Bill Barnes 2001-03-23 20:09:56 HOWTO for pg 7.1 installation from cvs