Thanks Tom. I'll stick with reforming things using a batch COPY command.
----- 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>
Sent: Tuesday, March 09, 2004 4:05 PM
Subject: Re: [NOVICE] Anyone have example C code for Asynchronous Command
> "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
In response to
pgsql-novice by date
|Next:||From: Ron St-Pierre||Date: 2004-03-09 16:03:52|
|Subject: Re: [NOVICE] JDBC driver & local server|
|Previous:||From: Tom Lane||Date: 2004-03-09 15:05:57|
|Subject: Re: Anyone have example C code for Asynchronous Command Processing? |