| From: | John Madden <weez(at)freelists(dot)org> |
|---|---|
| To: | "Morten W(dot) Petersen" <morten(at)esol(dot)no>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Can PostgreSQL be a mail backend? |
| Date: | 2001-02-27 13:54:57 |
| Message-ID: | 01022708545759.13156@weez |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)freelists(dot)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!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ned Lilly | 2001-02-27 13:56:14 | Re: Can PostgreSQL be a mail backend? |
| Previous Message | Robert Schrem | 2001-02-27 13:11:04 | Re: Query precompilation? |