> I'm wondering if postgres could be capable of acting as a
> mail storage. This would imply storing messages, from
> 1KB to > 100MB in size. The expected volume is 4000
> messages a day, and the database may store up to,
> lets say, 500000 messages.
>
> Could postgres cope with this? (How is the support for
> big data fields now BTW?)
It works quite well (designing a web-based system on it right now), but
because of a DDB::Pg limit, I can only get 8k into a 'text' field. So if
your app is web-based, you might want to not use perl...
John
--
# John Madden weez@freelists.org ICQ: 2EB9EA
# FreeLists, Free mailing lists for all: http://www.freelists.org
# UNIX Systems Engineer, Ivy Tech State College: http://www.ivy.tec.in.us
# Linux, Apache, Perl and C: All the best things in life are free!