From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
---|---|
To: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us, hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] Re: type coersion (was OR clause status) |
Date: | 1998-08-13 14:30:18 |
Message-ID: | 35D2F879.30817CCF@alumni.caltech.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> > The first thing I want to try is to substitute the operator for
> > types which are known to be binary-compatible and do not have their
> > own index defined.
Got a start on it :)
regression=> explain select * from tenk1 where oid = 3000;
NOTICE: QUERY PLAN:
Index Scan using tenk1_oid on tenk1 (cost=2.05 size=1 width=148)
EXPLAIN
So far, I've just done the right-hand form (the one with the constant on
the rhs of the expression). The left-hand form should be easy now.
So, just curious: if we stop here, and only match up binary-compatible
built-in types with available indices, then what v6.3.2 features/good
behaviors are still missing?
- Tom
The example is from the regression test database with an extra btree
index built on the tenk1 table...
regression=> \d tenk1
Table = tenk1
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| unique1 | int4
| 4 |
| unique2 | int4
| 4 |
| two | int4
| 4 |
| four | int4
| 4 |
| ten | int4
| 4 |
| twenty | int4
| 4 |
| hundred | int4
| 4 |
| thousand | int4
| 4 |
| twothousand | int4
| 4 |
| fivethous | int4
| 4 |
| tenthous | int4
| 4 |
| odd | int4
| 4 |
| even | int4
| 4 |
| stringu1 | name
| 32 |
| stringu2 | name
| 32 |
| string4 | name
| 32 |
+----------------------------------+----------------------------------+-------+
Indices: tenk1_hundred
tenk1_oid
tenk1_unique1
tenk1_unique2
regression=>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-08-13 14:32:50 | Re: [HACKERS] Table permissions problem |
Previous Message | Andreas Zeugswetter | 1998-08-13 14:22:40 | AW: AW: [HACKERS] Rule system |