I will search the archives but does anyone know off the top of their head which performs better?
----- Original Message ----- From: "Keith C. Perry" <[EMAIL PROTECTED]> To: "Rick Gigger" <[EMAIL PROTECTED]> Cc: "PgSQL General ML" <[EMAIL PROTECTED]> Sent: Tuesday, November 18, 2003 12:25 PM Subject: Re: [GENERAL] uploading files > Quoting Rick Gigger <[EMAIL PROTECTED]>: > > > What is the best method for storing files in postgres? Is it better to use > > the large object functions or to just encode the data and store it in a > > regular text or data field? > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 3: if posting/reading through Usenet, please send an appropriate > > subscribe-nomail command to [EMAIL PROTECTED] so that your > > message can get through to the mailing list cleanly > > > > Rick, > > This has been discussed recently so you might want to dig through the archives > but one thing to be aware of is that with large objects, you have have to dump > your database in a different format- a non-text format. This is less portable > than storing files as bytea's which can be dumped in the text and non-text > formats. Argueably is all you use is PosgreSQL then this might not be a big deal. > > Performance-wise I'm not qualified to speak to which is "better". As always, it > is going to depend on your specific application and environment. > > -- > Keith C. Perry, MS E.E. > Director of Networks & Applications > VCSN, Inc. > http://vcsn.com > > ____________________________________ > This email account is being host by: > VCSN, Inc : http://vcsn.com > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])