Re: COPY v. java performance comparison - Mailing list pgsql-general

From Adrian Klaver
Subject Re: COPY v. java performance comparison
Date
Msg-id 533CA612.3070902@aklaver.com
Whole thread Raw
In response to Re: COPY v. java performance comparison  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: COPY v. java performance comparison  (Rob Sargent <robjsargent@gmail.com>)
List 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.klaver@aklaver.com


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: SSD Drives
Next
From: Rob Sargent
Date:
Subject: Re: COPY v. java performance comparison