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.