From: | jim(at)reptiles(dot)org (Jim Mercer) |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | 6.5 indexes on timestamp/abstime don't appear to work |
Date: | 1999-06-02 00:18:59 |
Message-ID: | m10oykF-00080vC@mailbox.reptiles.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Your name : Jim Mercer
Your email address : jim(at)reptiles(dot)org
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium
Operating System (example: Linux 2.0.26 ELF) : FreeBSD 2.2.8
PostgreSQL version (example: PostgreSQL-6.5) : PostgreSQL-6.5beta1
Compiler used (example: gcc 2.8.0) : gcc
Please enter a FULL description of your problem:
------------------------------------------------
CREATE TABLE foo
(
mark abstime;
subnet inet;
bytes_in float8;
bytes_out float8;
);
CREATE INDEX foo_by_time ON foo (mark);
CREATE INDEX foo_by_subnet ON foo (subnet);
queries don't use foo_by_time
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
as above.
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Filip Zawadiak | 1999-06-02 11:58:02 | |
Previous Message | Heiko Klein | 1999-05-31 12:06:18 | Postgres-Solaris Socket Bug |