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 --------------------------
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
