Indexes not working, please help.

From: Ricardo Ryoiti Sugawara Junior <suga(at)netbsd(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Indexes not working, please help.
Date: 2002-07-05 04:18:02
Message-ID: Pine.LNX.4.44.0207050110580.1346-100000@ricardo.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi there.

The table medidas has the following structure:

Table "medidas"
Column | Type | Modifiers
------------+-----------------------------+-----------------------------------------------------
cod | bigint | not null default
nextval('"medidas_cod_seq"'::text)
cod_ponto | bigint |
data_hora | timestamp without time zone |
valor | smallint |
tipo_ponto | bytea |
unidade | bytea |
Indexes: teste
Primary key: medidas_pkey

I populated it with 8859000 entries using many "100 inserts"
blocks transactions. Inserting data on the table is no problem.
Althought I created the "teste" index ( create index teste on
medidas (cod) ), vacuumed and analyzed the database, pgsql still doesn't
use indexes.

explain select * from medidas where cod = 1231232;
---
NOTICE: QUERY PLAN:

Seq Scan on medidas (cost=0.00..197590.50 rows=1 width=36)
---

I've read all the documentation I found, but I couldn't figure out
what's happening. Setting "enable_seqscan" to false doesn't help either.
This machine I'm working on won't be the production server, but
it's not that slow machine (P3 1GHz, 384MB, ATA 100) and without indexes
working, that select mentioned above takes almost 60 seconds to run...

[]'s
Ricardo.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-05 04:34:12 Re: Indexes not working, please help.
Previous Message Justin Clift 2002-07-05 04:13:10 Re: Should next release by 8.0 (Was: Re: [GENERAL] I am being