the index on INTEGER field does not work (PG 7.1.2)

From: "Alexandr S(dot)" <say(at)infobus(dot)ru>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: the index on INTEGER field does not work (PG 7.1.2)
Date: 2001-06-15 06:23:43
Message-ID: 007c01c0f563$b9de60a0$2301a8c0@syberex.infobus.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


Bug: the index on INTEGER field does not work (PG 7.1.2).

Test 1:

1) create table test_int(id int primary key);

2) insert 10000 records in table test_int with perl program (values
1,2,3,...,10000).

3) 500 times execute query

SELECT * FROM test_int WHERE id = random number

(random number puts with perl program)

4) 500 queries executes for 30 seconds

Test 2:

1) create table test_int1(id int); (i.e. without primary key)

2) insert 10000 records in table test_int1 with perl program (values
1,2,3,...,10000).

3) 500 times execute query

SELECT * FROM test_int1 WHERE id = random number

(random number puts with perl program)

4) 500 queries executes for 30 seconds too :~-( ...

P.S. For TEXT field the same operations executes for 30 and 1 seconds
correspondingly.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Snow 2001-06-15 06:58:47 Re: the index on INTEGER field does not work (PG 7.1.2)
Previous Message Alexandr S. 2001-06-15 06:01:31 Bug: the index on INTEGER field does not work (PG 7.1.2)