| 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: | Whole Thread | Raw Message | 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 |