index problem

From: Tomka Gergely <tomka(at)zeus(dot)gau(dot)hu>
To: psql kezdő lista <pgsql-novice(at)postgresql(dot)org>
Subject: index problem
Date: 2005-01-10 19:11:46
Message-ID: Pine.LNX.4.58.0501102005030.21368@zeus.gau.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sorry for the noise, but:

tomka=> EXPLAIN SELECT ertek from meres where id=62;
QUERY PLAN
---------------------------------------------------------------
Seq Scan on meres (cost=0.00..462872.90 rows=220854 width=8)
Filter: (id = 62)
(2 rows)

In the table is approx 23 million lines.

tomka=> \d meres
Table "public.meres"
Column | Type | Modifiers
----------+------------------------+--------------------
ido | date | not null
hiheto | smallint | not null default 1
ertek | double precision | not null
dbido | date | not null
id | smallint | not null
ertekstr | character varying(200) | not null
Indexes:
"ix1" btree (id)
"ix2" btree (ido, id)
"ix3" btree (id, ido)

I am after a create/copy/vacuum full analyze.
psql (PostgreSQL) 7.4.6

So, what docs i need to read? :) I want to use the indexes, really.

--
Tomka Gergely
Tudom, anyu. Sapka, sál, doksi.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Fuhr 2005-01-10 20:06:14 Re: index problem
Previous Message Dirk Cleenwerck 2005-01-10 13:06:49 Re: postgresql or mysql or oracle?