Re: Pgsql vs Interbase: Transaction benchmark - Mailing list pgsql-general

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