Re: uploading files - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: uploading files
Date
Msg-id 20031118205057.K606@hermes.hilbert.loc
Whole thread Raw
In response to Re: uploading files  (Doug McNaught <doug@mcnaught.org>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: uploading files
Next
From: Doug McNaught
Date:
Subject: Re: uploading files