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

From Graeme B. Bell
Subject Re: large object write performance
Date
Msg-id 68E43830-5272-4AE7-AAF5-3887E2EB3C01@skogoglandskap.no
Whole thread Raw
In response to Re: large object write performance  (Bram Van Steenlandt <bram@diomedia.be>)
Responses Re: large object write performance
List 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 by date:

Previous
From: Bram Van Steenlandt
Date:
Subject: Re: large object write performance
Next
From: Bram Van Steenlandt
Date:
Subject: Re: large object write performance