> On 08 Oct 2015, at 13:50, Bram Van Steenlandt <bram@xxxxxxxxxxx> 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() libpq functions.” See * lobject seems to default to string handling in Python That’s going to be slow. Try using lo_import / export? Graeme Bell -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
