Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group