Re: Best COPY Performance

From: "Craig A(dot) James" <cjames(at)modgraph-usa(dot)com>
To: "Spiegelberg, Greg" <gspiegelberg(at)cranel(dot)com>
Cc: "Jim C(dot) Nasby" <jim(at)nasby(dot)net>, Worky Workerson <worky(dot)workerson(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Best COPY Performance
Date: 2006-10-25 17:28:05
Message-ID: 453F9EA5.9050302@modgraph-usa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Spiegelberg, Greg wrote:
>> The data are on two different computers, and I do processing
>> of the data as it passes through the application. Otherwise,
>> the INSERT INTO ... SELECT is my first choice.
>
> Would dblink() help in any way?

It might if perl wasn't so damned good at this. ;-)

Craig

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Atesz 2006-10-25 17:41:06 Re: ACCESS EXCLUSIVE lock
Previous Message Tom Darci 2006-10-25 17:20:42 query slows down drastically with increased number of fields