| From: | Michael Ben-Nes <miki(at)canaan(dot)co(dot)il> |
|---|---|
| To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
| Cc: | "Frank D(dot) Engel, Jr(dot)" <fde101(at)fjrhome(dot)net>, pgsql general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Large Objects |
| Date: | 2005-01-01 10:28:04 |
| Message-ID: | 41D67B34.2000103@canaan.co.il |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Joshua D. Drake wrote:
> Frank D. Engel, Jr. wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> I'd advise use of BYTEA as well. It's much simpler to work with than
>> the OIDs, and has simpler semantics. You do need to escape data
>> before handing it to the query string, and handle escaped results
>> (see the docs), but overall much nicer than working with OIDs.
>
>
> BYTEA is not always pragmatic. What is the file is 100 megs? 256 megs?
>
Intresting.
What is the size when bytea become inafective ?
Currently i keep all my products images in bytea record. is it practical ?
how slower is it then accessing an image on a file system ( like ext3 ) ?
Cheers
>
> pg_largeobject is more efficient than BYTEA for larger binaries.
>
> Sincerely,
>
> Joshua D. Drake
>
>
--
--------------------------
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
Cel: 972-52-8555757
Fax: 972-4-6990098
http://www.canaan.net.il
--------------------------
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jason Tesser | 2005-01-01 14:18:32 | Re: pgodbc error |
| Previous Message | Bruno Wolff III | 2004-12-31 21:51:23 | Re: 'distinct on' and 'order by' conflicts of interest |