Re: Can PostgreSQL be a mail backend?

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