From: | Doug McNaught <doug(at)mcnaught(dot)org> |
---|---|
To: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
Cc: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: uploading files |
Date: | 2003-11-18 20:09:45 |
Message-ID: | 87fzglqvzq.fsf@asmodeus.mcnaught.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> writes:
> > 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.
I think the field will still be competely loaded into memory on the
server side though, while LOs are stored in "chunks" and can
theoretically be streamed to the client. I'm not really a definitive
authority, though...
-Doug
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2003-11-18 20:22:56 | Re: uploading files |
Previous Message | Gaetano Mendola | 2003-11-18 20:03:31 | Re: Replicate PostgreSQL with rsync |
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2003-11-18 20:22:56 | Re: uploading files |
Previous Message | Karsten Hilbert | 2003-11-18 19:50:58 | Re: uploading files |