Skip site navigation (1) Skip section navigation (2)

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

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
Subject: Re: Anyone have example C code for Asynchronous Command Processing?
Date: 2004-03-09 15:05:57
Message-ID: 25080.1078844757@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
"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

Responses

pgsql-novice by date

Next:From: Tony and Bryn ReinaDate: 2004-03-09 15:07:27
Subject: Re: Anyone have example C code for Asynchronous Command Processing?
Previous:From: MohanDate: 2004-03-09 14:11:53
Subject: Re: JDBC driver & local server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group