From: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
---|---|
To: | PgSQL General ML <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: uploading files |
Date: | 2003-11-18 19:50:58 |
Message-ID: | 20031118205057.K606@hermes.hilbert.loc |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin 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
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2003-11-18 20:03:31 | Re: Replicate PostgreSQL with rsync |
Previous Message | Doug McNaught | 2003-11-18 19:36:24 | Re: uploading files |
From | Date | Subject | |
---|---|---|---|
Next Message | Doug McNaught | 2003-11-18 20:09:45 | Re: uploading files |
Previous Message | CoL | 2003-11-18 19:43:18 | Re: indexing with lower(...) -> queries are not optimised very well |