| From: | "Grace C(dot) Unson" <gracec(at)ntsp(dot)nec(dot)co(dot)jp> |
|---|---|
| To: | "PgSQL SQL" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Index not recognized |
| Date: | 2003-12-06 05:05:18 |
| Message-ID: | 001101c3bbb6$8b0db840$ec64a8c0@GREECE |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hello.
Why is it that my index for text[] data type is not recognized by the
Planner?
I did these steps:
1. create function textarr(text[]) returns text language sql as 'select
$1[1]' strict immutable
2. create index org_idx on EmpData (textarr(org));
3. vacuum full
4. explain analyze select name from EmpData where org *= 'math';
Result:
=========
Seq Scan on EmpData (cost=0.00..3193.20 rows=102 width=488)
(actual time=3.71.35..371.35 rows=0 loops=1)
Filter: (org[0]='math'::text)
Total runtime: 371.47 msec
(3 rows)
==========
I have 20,496 records. My postgres version is 7.3.
Any help is greatly appreciated.
Thank you..
Ace
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2003-12-06 12:27:26 | Re: What's wrong with COPY rights in 7.3.4? |
| Previous Message | David Shadovitz | 2003-12-05 21:51:20 | Fetch a single record |