Re: SERIAL or INT8 / Unique BLOB's

Jeffrey W. Baker wrote:

>
>yabbut, has anyone seen yet if 7.2 can use bigint in an index (on a 32-bit
>machine)?
>

I don't see why it wouldn't!  gcc has supported 8-byte longs for a
(*sigh*) long, long, time now. =)
This is on my i686-class linux box, build of yesterday's CVS snapshot:

test=# create table ttab(a int, b serial8);
NOTICE:  CREATE TABLE will create implicit sequence 'ttab_b_seq' for
SERIAL column 'ttab.b'
NOTICE:  CREATE TABLE / UNIQUE will create implicit index 'ttab_b_key'
for table 'ttab'
CREATE
test=# CREATE INDEX ttab_b_idx ON ttab (a);
CREATE
test=# CREATE FUNCTION populate(int) RETURNS bool AS '
test'#  BEGIN
test'#   FOR i IN 1..$1 LOOP
test'#    INSERT INTO ttab(a) VALUES((i*i)%133);
test'#   END LOOP;
test'#   RETURN true;
test'#  END; ' language 'plpgsql';
CREATE
test=# select populate(90000);
test=# EXPLAIN SELECT * FROM ttab WHERE a = 30 LIMIT 18;
NOTICE:  QUERY PLAN:

Limit  (cost=0.00..17.07 rows=5 width=12)
  ->  Index Scan using ttab_b_idx on ttab  (cost=0.00..17.07 rows=5
width=12)

EXPLAIN
test=# select * from ttab where a = 30 limit 10;
 a  |   b
----+--------
 30 | 136329
 30 | 136315
 30 | 136253
 30 | 136239
 30 | 136196
 30 | 136182
 30 | 136120
 30 | 136106
 30 | 136063
 30 | 136049
(10 rows)

-dj