On Tue, 18 Nov 2003, Rick Gigger wrote: > I will search the archives but does anyone know off the top of their head > which performs better?
lo_* but then I forgot to turn off compression on the bytea column. -- Nigel Andrews > > ----- 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 ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
