Re: Pgsql vs Interbase: Transaction benchmark

I think it's expected result.

In interbase you are using prepared statements.
PostgreSQL have got to parse, planing and etc. every time you pass a
statement.

"Denis Gasparin" <denis@edinet.it> �������/�������� � �������� ���������:
news:5.1.0.14.0.20010601161822.00a90010@10.1.1.2...
> 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@edinet.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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org