index problem
От | Tomka Gergely |
---|---|
Тема | index problem |
Дата | |
Msg-id | Pine.LNX.4.58.0501102005030.21368@zeus.gau.hu обсуждение исходный текст |
Ответы |
Re: index problem
|
Список | 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.
В списке pgsql-novice по дате отправления: