From: Grace C. Unson <gracec@ntsp.nec.co.jp>
To: PgSQL SQL <pgsql-sql@postgresql.org>
Subject: Index not recognized
Date: Sat, 6 Dec 2003 13:05:18 +0800
Message-ID: <001101c3bbb6$8b0db840$ec64a8c0@GREECE> (raw)
References: <3FD0A87B.4010803@scmbb.ulb.ac.be>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: gracec@ntsp.nec.co.jp
Subject: Re: Index not recognized
In-Reply-To: <001101c3bbb6$8b0db840$ec64a8c0@GREECE>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox