Re: large object write performance - Mailing list pgsql-performance

From Bram Van Steenlandt
Subject Re: large object write performance
Date
Msg-id 56167A26.1020207@diomedia.be
Whole thread Raw
In response to Re: large object write performance  ("Graeme B. Bell" <graeme.bell@nibio.no>)
List pgsql-performance

Op 08-10-15 om 15:10 schreef Graeme B. Bell:
>>> http://initd.org/psycopg/docs/usage.html#large-objects
>>>
>>>
>>> "Psycopg large object support *efficient* import/export with file system files using the lo_import() and
lo_export()libpq functions.” 
>>>
>>> See *
>>>
>> I was under the impression they meant that the lobject was using lo_import and lo_export.
>> I can't seem to find how to use lo_import en export, I searched google and came to the conclusion the lobject was
theway to go. 
>>>>> x.lo_import()
>> Traceback (most recent call last):
>>    File "<stdin>", line 1, in <module>
>> AttributeError: 'psycopg2._psyco
> Bram,
>
> I recommend posting this as a question on a python/psycopg mailing list, for advice.
> You are probably not the first person to encounter it.
>
> Graeme Bell
>
>
>
Hi,

I tried \lo_import with psql and it's not faster, the same 5.5megabytes/sec.

Bram


pgsql-performance by date:

Previous
From: "Graeme B. Bell"
Date:
Subject: Re: large object write performance
Next
From: "Carlo"
Date:
Subject: Re: One long transaction or multiple short transactions?