Re: Improving speed of copy

From: "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>
To: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
Cc: Pgsql-hackers(at)postgresql(dot)org
Subject: Re: Improving speed of copy
Date: 2002-09-20 17:41:24
Message-ID: Pine.LNX.4.21.0209201838590.599-100000@ponder.fairway2k.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-09-20 17:53:49 Re: Win32 rename()/unlink() questions
Previous Message Bruce Momjian 2002-09-20 17:31:27 Re: Win32 rename()/unlink() questions