Re: About large objects asynchronous and non-blocking support - Mailing list pgsql-hackers

From Giovanni Mascellani
Subject Re: About large objects asynchronous and non-blocking support
Date
Msg-id 51B2413F.8010305@gmail.com
Whole thread Raw
In response to Re: About large objects asynchronous and non-blocking support  (Dmitriy Igrishin <dmitigr@gmail.com>)
Responses Re: About large objects asynchronous and non-blocking support  (Dmitriy Igrishin <dmitigr@gmail.com>)
List pgsql-hackers
Hi.

Il 05/06/2013 22:52, Dmitriy Igrishin ha scritto:
>> At the moment libpq doesn't seem to support asynchronous and
>> non-blocking support for large objects, in the style of
>> PQsendQuery/PQgetResult. This makes large objects hardly suited for
>> single-threaded programs based on some variant of select().
>>
> According to http://www.postgresql.org/docs/9.2/static/lo-funcs.html
> "There are server-side functions callable from SQL that correspond to each
> of
> the client-side functions". Hence, you can call these functions by using
> asynchronous API.

Thanks, I'll try this way (BTW, it may help to specify on the
documentation that lo_read and lo_write lose the "_"). I wonder whether
having to escape all the content for lowrite  can't have a negative
impact on performances. It shouldn't be too bad for my case, though.

Giovanni.
--
Giovanni Mascellani <mascellani@poisson.phc.unipi.it>
Pisa, Italy

Web: http://poisson.phc.unipi.it/~mascellani
Jabber: g.mascellani@jabber.org / giovanni@elabor.homelinux.org


pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Freezing without write I/O
Next
From: Hannu Krosing
Date:
Subject: Re: Freezing without write I/O