X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8B9F2D1B538 for ; Tue, 18 Nov 2003 19:57:43 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 98338-09 for ; Tue, 18 Nov 2003 15:57:13 -0400 (AST) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by svr1.postgresql.org (Postfix) with SMTP id AB836D1B52D for ; Tue, 18 Nov 2003 15:57:10 -0400 (AST) Received: (qmail 2836 invoked by uid 65534); 18 Nov 2003 19:56:51 -0000 Received: from p5087E082.dip0.t-ipconnect.de (EHLO hermes.hilbert.loc) (80.135.224.130) by mail.gmx.net (mp021) with SMTP; 18 Nov 2003 20:56:51 +0100 X-Authenticated: #1433807 Received: (from ncq@localhost) by hermes.hilbert.loc (8.11.6/8.11.6/SuSE Linux 0.5) id hAIJowI11035 for pgsql-general@postgresql.org; Tue, 18 Nov 2003 20:50:58 +0100 Date: Tue, 18 Nov 2003 20:50:58 +0100 From: Karsten Hilbert To: PgSQL General ML Subject: Re: uploading files Message-ID: <20031118205057.K606@hermes.hilbert.loc> Mail-Followup-To: PgSQL General ML References: <1069164075.986.239.camel@bbking.uio.no> <20031118142919.GI4953@libertyrms.info> <1069180780.2769.91.camel@haggis.homelan> <019301c3ae07$d714e220$0700a8c0@trogdor> <87llqdqy37.fsf@asmodeus.mcnaught.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <87llqdqy37.fsf@asmodeus.mcnaught.org> User-Agent: Mutt/1.3.22.1i Re-X-turn-receipt-to: Karsten.Hilbert@gmx.net Di-X-sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi-X-rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri-X-ority: 2 (High) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/939 X-Sequence-Number: 52589 > Depends on whether you need "random access" to the contents. You can > lo_seek() inside a large object and retrieve parts of the data with > lo_read(), while 'text' and 'bytea' currently require fetching the > whole file. Not so unless I misunderstand. We use substr() on bytea for chunking access to large files on OSs with inferior TCP/IP buffer implementations. That's probably suboptimal performance-wise, though. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346