Skip site navigation (1) Skip section navigation (2)

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

From: Andrew Snow <andrew(at)modulus(dot)org>
To: "Alexandr S(dot)" <say(at)infobus(dot)ru>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: the index on INTEGER field does not work (PG 7.1.2)
Date: 2001-06-15 06:58:47
Message-ID: 20010615165839.E17690-100000@esper.modulus.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Please see FAQ 4.9


http://postgresql.bteg.net/docs/faq-english.html#4.9



On Fri, 15 Jun 2001, Alexandr S. wrote:

>
> 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.
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>


In response to

Responses

pgsql-bugs by date

Next:From: Le Gourou qui fait le supportDate: 2001-06-15 11:23:10
Subject: pg_dumpall problem
Previous:From: Alexandr S.Date: 2001-06-15 06:23:43
Subject: the index on INTEGER field does not work (PG 7.1.2)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group