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
