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

[Alexandr S.]

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 1 records in table test_int with perl program (values
1,2,3,...,1).

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 1 records in table test_int1 with perl program (values
1,2,3,...,1).

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 [EMAIL PROTECTED]

[BUGS] bug reporting

[Alexandr S]

Pgadmin 3.1 don t work (operations like insert rows) with columns  named 
in russian language (title of column in russian language). But the same 
operations using PhpPgAdmin - all works very  well, right. And if 
replace russian title of column with equivalent in english - all works 
very well.PgAdmin responds the message: "2003-10-03 14:15:15 ERROR  
: Column not found in pgSet: еще_колонка".  Operation System: Windows 
XP,  distribution binary (zip), language russian.

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster