Re: Pgsql vs Interbase: Transaction benchmark

From: Denis Gasparin <denis(at)edinet(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Pgsql vs Interbase: Transaction benchmark
Date: 2001-06-01 14:21:02
Message-ID: 5.1.0.14.0.20010601161822.00a90010@10.1.1.2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2001-06-01 15:07:14 Re: [GENERAL] Compiling to RPM setup/filesystem layout
Previous Message Tom Lane 2001-06-01 14:14:26 Re: Pgsql vs Interbase: Transaction benchmark