pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Bram Van Steenlandt <bram@diomedia.be>
To: pgsql-performance@postgresql.org
Subject: Re: large object write performance
Date: Thu, 08 Oct 2015 16:13:58 +0200
Message-ID: <56167A26.1020207@diomedia.be> (raw)
In-Reply-To: <E776D57D-2F9D-4DD1-AF83-696F93A31A50@skogoglandskap.no>
References: <561634BD.2000309@diomedia.be>
	<3D2F06B8-297D-48CF-AA8C-47FD70925863@skogoglandskap.no>
	<56164825.6050209@diomedia.be>
	<F25A42D9-8A3D-4DC4-A25D-E3FD1A01C43F@skogoglandskap.no>
	<5616588B.5000308@diomedia.be>
	<68E43830-5272-4AE7-AAF5-3887E2EB3C01@skogoglandskap.no>
	<561661A8.90301@diomedia.be>
	<E776D57D-2F9D-4DD1-AF83-696F93A31A50@skogoglandskap.no>
List-Unsubscribe:  <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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 the way 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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



view thread (12+ messages)

Message-ID: <56167A26.1020207@diomedia.be>
Permalink:  ../56167A26.1020207@diomedia.be/
Also on:    postgresql.org/message-id/56167A26.1020207@diomedia.be

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: bram@diomedia.be
  Subject: Re: large object write performance
  In-Reply-To: <56167A26.1020207@diomedia.be>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox