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.

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

2006-06-05 Thread Greg
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 objects in a separate table