Re: COPY v. java performance comparison

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: COPY v. java performance comparison
Date: 2014-04-03 00:06:42
Message-ID: 533CA612.3070902@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04/02/2014 02:27 PM, Rob Sargent wrote:
> On 04/02/2014 03:11 PM, Adrian Klaver wrote:
>> On 04/02/2014 02:04 PM, Rob Sargent wrote:
>>> On 04/02/2014 02:36 PM, Adrian Klaver wrote:
>>>> On 04/02/2014 01:14 PM, Rob Sargent wrote:
>>>>> On 04/02/2014 01:56 PM, Steve Atkins wrote:

>>
>> Have you tried moving the input file to the same disk as the server,
>> to factor out the controller?
>>
> I labour under the delusion that it is through the controller one reads
> and writes and that there might be some slight advantage to not doing
> both against one drive if avoidable. Wrong again?

Well there is one way to find out:)

Might try with something less then the whole file to get come up an
approximate row/sec rate.

>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2014-04-03 00:11:19 Re: COPY v. java performance comparison
Previous Message Scott Marlowe 2014-04-02 22:56:08 Re: SSD Drives