Re: Anyone have example C code for Asynchronous Command Processing?

Thanks Tom. I'll stick with reforming things using a batch COPY command.

-Tony

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Tony and Bryn Reina" <reina_ga@hotmail.com>
Cc: <pgsql-novice@postgresql.org>
Sent: Tuesday, March 09, 2004 4:05 PM
Subject: Re: [NOVICE] Anyone have example C code for Asynchronous Command
Processing?


> "Tony and Bryn Reina" <reina_ga@hotmail.com> writes:
> > Would the 2 connections execute
> > faster than running the 2 commands serial over the same connection?
>
> Perhaps, but you'd get much more win out of batching multiple inserts
> into one COPY.  The overhead of parsing an INSERT command is relatively
> high compared to what it actually gets done.  Running two in parallel
> does nothing to improve the overhead situation; and if you are after
> speed, cutting the overhead is where you *must* focus your attention.
> (If you just gotta have the sex appeal of parallelism, try running two
> COPY operations in parallel...)
>
> regards, tom lane
>