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

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

From: "Tony and Bryn Reina" <reina_ga(at)hotmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Anyone have example C code for Asynchronous Command Processing?
Date: 2004-03-09 15:07:27
Message-ID: BAY8-DAV44hJTANZwwP0001cda4@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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
>

In response to

pgsql-novice by date

Next:From: Ron St-PierreDate: 2004-03-09 16:03:52
Subject: Re: [NOVICE] JDBC driver & local server
Previous:From: Tom LaneDate: 2004-03-09 15:05:57
Subject: Re: Anyone have example C code for Asynchronous Command Processing?

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