Horton

Re: [PATCH 4/4] Add tests to dblink covering use of COPY TO FUNCTION

Simon Riggs <simon@2ndquadrant.com>

View thread View on postgr.es
From: Simon Riggs <simon@2ndQuadrant.com>
To: Jeff Davis <pgsql@j-davis.com>
Cc: Daniel Farina <drfarina@gmail.com>, Pavel Stehule <pavel.stehule@gmail.com>, Hannu Krosing <hannu@krosing.net>, Greg Smith <greg@2ndquadrant.com>, Robert Haas <robertmhaas@gmail.com>, Daniel Farina <dfarina@truviso.com>, pgsql-hackers@postgresql.org
Date: 2009-11-27T13:39:43Z
Lists: pgsql-hackers 
On Tue, 2009-11-24 at 22:13 -0800, Jeff Davis wrote:

> My disagreement with the row-by-row approach is more semantics than
> performance. COPY translates records to bytes and vice-versa, and your
> original patch maintains those semantics.

The bytes <-> records conversion is a costly one. Anything we can do to
avoid that in either direction will be worth it. I would regard
performance as being part/most of the reason to support this.

-- 
 Simon Riggs           www.2ndQuadrant.com