int8 indices?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)pl>
To: pgsql-general(at)postgresql(dot)org
Subject: int8 indices?
Date: 2001-08-07 06:43:14
Message-ID: 20010807084314.05eb79d1.depesz@depesz.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi
my postgresql is:
depesz=# select version();
version
---------------------------------------------------------------
PostgreSQL 7.2devel on i686-pc-linux-gnu, compiled by GCC 3.0
(1 row)

(compiled from cvs 2 days ago).

int8 are working:
depesz=# select 2147483648::int4+1::int4;
ERROR: pg_atoi: error reading "2147483648": Numerical result out of range
depesz=# select 2147483648::int8+1::int8;
?column?
------------
2147483649

not i have table a:
depesz=# \d a
Table "a"
Column | Type | Modifiers
--------+--------+-----------
id | bigint |
Unique keys: aaa

depesz=# \d aaa
Index "aaa"
Column | Type
--------+--------
id | bigint
unique btree

depesz=# select count(*) from a;
count
-------
25981
(1 row)

(all of them are not nul:
depesz=# select count(*) from a where id is not null;
count
-------
25981
(1 row)
)

of course i vacuum'ed, but when i select anything from the table i get
seqscan:
depesz=# explain select * from a where id = 6970;
NOTICE: QUERY PLAN:

Seq Scan on a (cost=0.00..465.76 rows=1 width=8)

EXPLAIN

what could be possible reason?

depesz

--
hubert depesz lubaczewski http://www.depesz.pl/
------------------------------------------------------------------------
... and the end of all our exploring will be to arrive where we started
and know the place for the first time. -- T. S. Eliot

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Timo Lehtinen 2001-08-07 08:04:17 Re: Starting Postgre
Previous Message Sundararajan 2001-08-07 05:18:20 help on delete trigger.