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(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tony and Bryn Reina" <reina_ga(at)hotmail(dot)com>
Cc: <pgsql-novice(at)postgresql(dot)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(at)hotmail(dot)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
>