Hi to all!
I'm doing some benchmarks to test Interbase vs PostgreSQL. The
test are done with the respective PHP client. The two servers are installed
on the same machine with RedHat 7.0.
Pgsql has been started with these configuration options:
- sort_mem = 512
- fsync
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're
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),