Re: [GENERAL] Pgsql vs Interbase: Transaction benchmark

[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're actually getting indexscan
plans?

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster