I've set up in memory transfers using copy - you do that with the stdout
option. Performance is very good if you're on the same machine as the sql
server. Obviously network is the bottleneck otherwise.
On May 20, 2015 8:24 AM, "Ravi Krishna" <srkrishna(at)gmx(dot)com> wrote:
>
> > Anyway, taking the function name 'bulk' into account - I think you want
> > find the best way to to insert a large number of row/records.
> >
> > Review the 'copy' command to populate a database:
> > http://www.postgresql.org/docs/9.1/static/populate.html - read
> > carefully as it will increase performance in a dramatic way.
>
> I am aware of the copy command, but we are talking about application
> inserting rows from a C++ task
> with values coming in variables. Does COPY handle that? COPY looks more
> closer to sqlloader of Oracle.
>
> DB2 Bulkcopy API is damn good. We have applications inserting tens of rows
> in one single call.
>
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>