Re: [GENERAL] Best way to store and retrieve large objects in database for email program

2006-06-05 Thread Wayne Conrad
Daniel's answer reflects our experience with large objects. We recently switch our 50-or-so G of stored postscript documents from large objects to bytea, but only because we're going to use Slony for our "more-availability" setup and Slony doesn't replicate large objects.

Re: [GENERAL] Best way to store and retrieve large objects in

2006-06-05 Thread Daniel Verite
Greg wrote: > I am creating an email client that will contain email messages. Now a > message may have multiple large attachments. > > > > 1.)Would the best way to store these large objects be in an oid field? > > 2.)I assume for performance reasons I should place these large