Re: [GENERAL] Pgsql vs Interbase: Transaction benchmark

2001-06-01 Thread Denis Gasparin
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

Re: [GENERAL] Pgsql vs Interbase: Transaction benchmark

2001-06-01 Thread Tom Lane
Denis Gasparin <[EMAIL PROTECTED]> 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