Re: uploading files
Karsten Hilbert <karsten.hilbert@gmx.net>
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: PgSQL General ML <pgsql-general@postgresql.org>
Date: 2003-11-18T19:50:58Z
Lists: 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