From: | Frank Mandarino <fam(at)risca(dot)com> |
---|---|
To: | Herouth Maoz <herouth(at)oumail(dot)openu(dot)ac(dot)il> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] btree index on a char(8) field (fwd) |
Date: | 1999-10-07 03:47:32 |
Message-ID: | 99Oct6.234802edt.115201@sky.risca.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hermouth,
Thank you so much for your reply! You were exactly right. I re-created
the index with bpchar_ops, and explain now outputs:
Index Scan using ven_code_idx on vendor (cost=2.05 rows=2 width=36)
instead of
Seq Scan on vendor (cost=738.86 rows=2 width=36)
Queries are obviously much faster now.
I am unable to find any reference to bpchar_ops in the the documentation
or the General and SQL mailing list archives. Can you tell me where I
could find out more about what "_ops" are available and what they all
mean?
Thanks again,
../fam
--
Frank A. Mandarino
fam(at)risca(dot)com
On Wed, 6 Oct 1999, Herouth Maoz wrote:
> At 15:30 +0200 on 06/10/1999, Frank Mandarino wrote:
>
>
> > main=> create index ven_code_idx on vendor using btree (ven_code char_ops);
> > CREATE
>
> I didn't have time to check this, but the problem may be caused by the
> incorrect ops you are using. For char(N) it should be bpchar_ops, not
> char_ops.
>
> Herouth
>
> --
> Herouth Maoz, Internet developer.
> Open University of Israel - Telem project
> http://telem.openu.ac.il/~herutma
>
>
>
> ************
>
From | Date | Subject | |
---|---|---|---|
Next Message | Gene Selkov, Jr. | 1999-10-07 04:42:58 | Re: [GENERAL] btree index on a char(8) field (fwd) |
Previous Message | Bruce Momjian | 1999-10-07 03:17:19 | Re: PostgreSQL vs Mysql comparison |