Hi,
I'm considering building a database with a table which stores entire
e-mail messages, up to around 128kB.
- How does PostgreSQL cope with tables with huge amounts of data in a
TEXT column? Let's say 50,000 rows of e-mail messages with an average
e-mail size of 20kB, with maybe 5% of the messages over 100kB.
- Is it better to use the large-object interface? I'd rather avoid
this as it's a bit clunky.
- Is it better to store the messages as files and have the database
hold filenames? I'd *really* rather not do this...
Regards,
David.