Howard Cole wrote:
Hi,
I am going to create binary objects in a database which are compressed
eml files (1K - 10 Mbytes in size). Am I better using the bytea or large
objects?
Is there still an issue with backup and restore of databases using large
objects with pg_dump/restore?
Thanks in advance.
Howard Cole
www.selestial.com
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
I've just re-written our Whitebeam code to drop large-objects in favour of BYTEA fields.
All the old problems of large objects in backups exist, but the killer for us was that none of the current replication systems, at least that I could
find, would replicate large objects. This became a mandatory requirements for us.
I'd have to have a *very* good reason to use large objects over BYTEA now.
Pete
--
http://www.whitebeam.org
http://www.yellowhawk.co.uk
-----
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
