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.
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