| From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
|---|---|
| To: | "Ed L(dot)" <pgsql(at)bluepolka(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Image storage questions |
| Date: | 2005-05-18 21:07:18 |
| Message-ID: | 428BAE86.9050106@commandprompt.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
>
> Can you or anyone share your experiences with using blobs as
> opposed to bytea or storing externally? I'm particularly
> interested to know if loading a large number of images is going
> to crowd my DB cache?
Large Objects stream (for lack of a better term) to the client in 8k?
chunks so it typically isn't too bad.
Bytea gives you everything all at once which is fine for small objects.
External storing is useful but I prefer LO because all my data (binary
and meta) is all in the same place for management.
Sincerely,
Joshua D. Drake
>
> Ed
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-05-18 21:10:54 | Re: Image storage questions |
| Previous Message | Ed L. | 2005-05-18 21:03:42 | Re: Image storage questions |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-05-18 21:10:54 | Re: Image storage questions |
| Previous Message | Ed L. | 2005-05-18 21:03:42 | Re: Image storage questions |