Re: Pgsql vs Interbase: Transaction benchmark

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Denis Gasparin <denis(at)edinet(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Pgsql vs Interbase: Transaction benchmark
Date: 2001-06-01 14:14:26
Message-ID: 726.991404866@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Denis Gasparin 2001-06-01 14:21:02 Re: Pgsql vs Interbase: Transaction benchmark
Previous Message d0 2001-06-01 13:51:15 function and trigger action/use