Re: Can PostgreSQL be a mail backend? - Mailing list pgsql-general

From John Madden
Subject Re: Can PostgreSQL be a mail backend?
Date
Msg-id 01022708545759.13156@weez
Whole thread Raw
In response to Can PostgreSQL be a mail backend?  ("Morten W. Petersen" <morten@esol.no>)
List pgsql-general
> 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!

pgsql-general by date:

Previous
From: Tulio Oliveira
Date:
Subject: Re: Permission denied while insert
Next
From: "Stephen Livesey"
Date:
Subject: Slowdown problem when writing 1.7million records