Re: Anyone have example C code for Asynchronous Command Processing? - Mailing list pgsql-novice

From Tom Lane
Subject Re: Anyone have example C code for Asynchronous Command Processing?
Date
Msg-id 4165.1078761060@sss.pgh.pa.us
Whole thread Raw
In response to Anyone have example C code for Asynchronous Command Processing?  (reina_ga@hotmail.com (Tony Reina))
Responses Re: Anyone have example C code for Asynchronous Command Processing?
List pgsql-novice
reina_ga@hotmail.com (Tony Reina) writes:
> I'm using libpq to dump some text files into a PostgreSQL database.
> It's just a bunch of "INSERT INTO" calls, but they block one another
> waiting for the INSERT command to return. I think I can speed things
> up by using asynchronous command processing (e.g. PQsendQuery,
> PQgetResult).

No you can't, because you can't have multiple commands pending over a
single connection.

You would get significantly more speedup by using COPY, anyway.

            regards, tom lane

pgsql-novice by date:

Previous
From: reina_ga@hotmail.com (Tony Reina)
Date:
Subject: Anyone have example C code for Asynchronous Command Processing?
Next
From: "Marcus Andree S. Magalhaes"
Date:
Subject: Re: Anyone have example C code for Asynchronous Command Processing?