Horton

Re: Improving speed of copy

Nigel J. Andrews <nandrews@investsystems.co.uk>

View thread View on postgr.es
From: "Nigel J. Andrews" <nandrews@investsystems.co.uk>
To: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
Cc: Pgsql-hackers@postgresql.org
Date: 2002-09-20T17:41:24Z
Lists: pgsql-hackers 
On Fri, 20 Sep 2002, Shridhar Daithankar wrote:

> In select test where approx. 15 rows where reported with query on index field, 
> mysql took 14 sec. and psotgresql took 17.5 sec. Not bad but other issues 
> eclipse the result..

I don't know about anyone else but I find this aspect strange. That's 1 second
(approx.) per row retrieved. That is pretty dire for an index scan. The
data/index must be very non unique.


-- 
Nigel J. Andrews