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
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. |