| 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: | Whole Thread | Raw Message | 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
| 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 |