Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-performance-owner+M53556=pgsql-performance-ar@postgresql.org>)
 id 1ZkBxS-0004Nk-Pm
 for pgsql-performance@arkaria.postgresql.org; Thu, 08 Oct 2015 14:14:11 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.84) (envelope-from
 <pgsql-performance-owner+M53556=pgsql-performance-ar@postgresql.org>)
 id 1ZkBxS-0006Od-4k
 for pgsql-performance@arkaria.postgresql.org; Thu, 08 Oct 2015 14:14:10 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <bram@diomedia.be>) id 1ZkBxR-0006Nx-1M
 for pgsql-performance@postgresql.org; Thu, 08 Oct 2015 14:14:09 +0000
Received: from mail.tivas.info ([85.234.217.139])
 by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256)
 (Exim 4.84) (envelope-from <bram@diomedia.be>) id 1ZkBxJ-0006t1-US
 for pgsql-performance@postgresql.org; Thu, 08 Oct 2015 14:14:07 +0000
Received: from localhost.localdomain ([192.168.3.104])
 by mail.tivas.info (8.14.7/8.14.7) with ESMTP id t98EDwtT007848
 for <pgsql-performance@postgresql.org>; Thu, 8 Oct 2015 16:13:58 +0200 (CEST)
 (envelope-from bram@diomedia.be)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=diomedia.be; s=mail;
 t=1444313638; bh=wV0gEabMb+if+XXjz+ipwrirORWTnlMA4jeLjJb048g=;
 h=Date:From:To:Subject:References:In-Reply-To;
 b=CrqP684qs1DjLj6r8QwGfcFGDINUz7As+Wha80luLI4md8nnbuMr3yGVnz78cL9mE
 x71cGzit5Ra8viunfiYgweJ72fsjw+xScaT3NGJy1wMX4gSVLtTSREukg4Z852TMHP
 DVIUFrfwvRr1RoG5bUsabroaZFyb8sgQxubeh/aE=
Message-ID: <56167A26.1020207@diomedia.be>
Date: Thu, 08 Oct 2015 16:13:58 +0200
From: Bram Van Steenlandt <bram@diomedia.be>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.6.0
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: large object write performance
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>
In-Reply-To: <E776D57D-2F9D-4DD1-AF83-696F93A31A50@skogoglandskap.no>
Content-Type: text/plain; charset=windows-1252; format=flowed
Content-Transfer-Encoding: 8bit
X-MessageSniffer-RulebaseUTC: 20150811174000
X-MessageSniffer-Identifier: <56167A26.1020207@diomedia.be>
X-GBUdb-Analysis: 0, 192.168.3.104, Ugly c=0.414814 p=-0.535714 Source Normal
X-MessageSniffer-Scan-Result: 0
X-MessageSniffer-Rules: 0-0-0-3140-c
X-Pg-Spam-Score: -2.0 (--)
List-Archive: <http://archives.postgresql.org/pgsql-performance>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-performance.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@postgresql.org>
List-Post: <mailto:pgsql-performance@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-performance>
List-Unsubscribe: 
 <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
X-Mailing-List: pgsql-performance
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org



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