Denis Gasparin <denis(at)edinet(dot)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