Re: large object write performance

Поиск
Список
Период
Сортировка
От Graeme B. Bell
Тема Re: large object write performance
Дата
Msg-id 68E43830-5272-4AE7-AAF5-3887E2EB3C01@skogoglandskap.no
обсуждение исходный текст
Ответ на Re: large object write performance  (Bram Van Steenlandt <bram@diomedia.be>)
Ответы Re: large object write performance
Список pgsql-performance
> On 08 Oct 2015, at 13:50, Bram Van Steenlandt <bram@diomedia.be> wrote:
>>> 1. The part is "fobj = lobject(db.db,0,"r",0,fpath)", I don't think there is anything there

Re: lobject

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()
libpqfunctions.” 

See *

lobject seems to default to string handling in Python
That’s going to be slow.
Try using lo_import / export?

Graeme Bell

В списке pgsql-performance по дате отправления:

Предыдущее
От: Bram Van Steenlandt
Дата:
Сообщение: Re: large object write performance
Следующее
От: Bram Van Steenlandt
Дата:
Сообщение: Re: large object write performance