6.5 indexes on timestamp/abstime don't appear to work
| От | jim@reptiles.org (Jim Mercer) |
|---|---|
| Тема | 6.5 indexes on timestamp/abstime don't appear to work |
| Дата | |
| Msg-id | m10oykF-00080vC@mailbox.reptiles.org обсуждение исходный текст |
| Список | pgsql-bugs |
Your name : Jim Mercer Your email address : jim@reptiles.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: ---------------------------------------------------------------------
В списке pgsql-bugs по дате отправления: