Skip site navigation (1) Skip section navigation (2)

6.5 indexes on timestamp/abstime don't appear to work

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: (view raw, whole thread or download thread mbox)
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:

  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:

pgsql-bugs by date

Next:From: Filip ZawadiakDate: 1999-06-02 11:58:02
Previous:From: Heiko KleinDate: 1999-05-31 12:06:18
Subject: Postgres-Solaris Socket Bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group