Re: Bug: the index on INTEGER field does not work (PG 7.1.2) - Mailing list pgsql-bugs

From Peter Eisentraut
Subject Re: Bug: the index on INTEGER field does not work (PG 7.1.2)
Date
Msg-id Pine.LNX.4.30.0106201757460.725-100000@peter.localdomain
Whole thread Raw
In response to Bug: the index on INTEGER field does not work (PG 7.1.2)  ("Alexandr S." <say@infobus.ru>)
List pgsql-bugs
Alexandr S. writes:

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

2.5) vacuum analyze

> 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

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter

pgsql-bugs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: pg_ctl restart just appends to command line instead of regenerating original cmd
Next
From: Peter Eisentraut
Date:
Subject: Re: Update is not atomic