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

Re: async fast-path calls?

From: yamt(at)mwd(dot)biglobe(dot)ne(dot)jp (YAMAMOTO Takashi)
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: async fast-path calls?
Date: 2011-01-15 13:17:53
Message-ID: 20110115131753.2E84A19CE4B@mail.netbsd.org (view raw or flat)
Thread:
Lists: pgsql-novice
hi,

i workarounded this by using PQsendQuery with eg. "select lowrite($1,$2)".
while it seems to work, i wonder if it's ok to use these functions this way,
given that only some of large object server-side functions are documented
in http://www.postgresql.org/docs/9.0/interactive/lo-funcs.html.

YAMAMOTO Takashi

> hi,
> 
> is there any easy way to issue large object operations like lo_write,
> or more generally fast-path calls, asynchronously?  (async in the sense
> of PQsendQuery so that i can poll to wait a result)
> 
> background: i want to use multiple connections to the server in a single
> application for performance reasons.  the application is single-threaded.
> (multi threading is not possible because i need to use a
> pthread-incompatible library.)
> using synchronous api when another asynchronous command is in-progress is
> deadlock-prone as i can't receive the result of asynchronous one until
> the synchronous one finishes.
> 
> YAMAMOTO Takashi

In response to

Responses

pgsql-novice by date

Next:From: Frank BaxDate: 2011-01-15 13:19:25
Subject: Re: join with 1 row limit
Previous:From: Vibhor KumarDate: 2011-01-15 11:45:50
Subject: Re: join with 1 row limit

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