Re: Pgsql vs Interbase: Transaction benchmark

The table definition is:
CREATE TABLE ADDRESS (
GROUPID INTEGER NOT NULL,
ADDRESSID INTEGER NOT NULL,
NAME VARCHAR(256) NOT NULL,
SURNAME VARCHAR(256) NOT NULL,
ADDRESS VARCHAR(256),
PHONE VARCHAR(256),
EMAIL VARCHAR(256),
FAX VARCHAR(256),
PRIMARY KEY(GROUPID,ADDRESSID)
);

The explain command gives me these results:
explain SELECT * FROM ADDRESS1 WHERE GROUPID = 5 AND ADDRESSID = 1000;
NOTICE: QUERY PLAN:

Index Scan using address1_pkey on address1 (cost=0.00..2.02 rows=1 width=92)

(PS: There are 100 groups of 10000 recors each => 1.000.000 records)

Denis

At 16.14 01/06/01, Tom Lane wrote:
>Denis Gasparin <denis(at)edinet(dot)it> writes:
> > All the operations are perfomed in the same table with 1.000.000 of
> records
> > and the searches (those specified by the WHERE clause of SELECT and
> UPDATE)
> > are done only on the primary key of the table itself.
>
>Have you checked (with EXPLAIN) that you're actually getting indexscan
>plans?
>
> regards, tom lane