Re: large object write performance

Поиск
Список
Период
Сортировка
От Bram Van Steenlandt
Тема Re: large object write performance
Дата
Msg-id 56167A26.1020207@diomedia.be
обсуждение исходный текст
Ответ на Re: large object write performance  ("Graeme B. Bell" <graeme.bell@nibio.no>)
Список 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 по дате отправления:

Предыдущее
От: "Graeme B. Bell"
Дата:
Сообщение: Re: large object write performance
Следующее
От: "Carlo"
Дата:
Сообщение: Re: One long transaction or multiple short transactions?