Re: [exim] exim + sql relay

Richard P. Welty wrote:
> W B Hacker wrote:
>> If you expect to knock PG down under the sort of lightweight loads an MTA
>> brings, you must have one Hell of a user base.
>
> without going into details that i shouldn't, i'm looking at the
> rollout of a new consumer product with an email component which
> represents only part of the load on the database.
>
> this means, among other things, i'm looking at a hockey stick
> sales curve and corresponding ramp in user base size. this
> isn't going to be like your normal corporate or college email
> plant. i'm still doing load testing with newly built servers,
> trying to push things to destruct to see what it actually takes
> to make them fall over, and yes, i can probably support a
> multitude of users on a single well chosen system just for
> inbound email, but that's only a small part of the equation.
>
> richard
>

ACK.. Exim-postgresql was originally an afterthought on Zope/Plone CMS websites
for us.

But you should seek info - not on Exim, which can be very light DB load when
intelligently configured - but rather in POS, CMS, & transactional DB forums for
benchmarks, case history, barriers, etc.

PostgreSQL is older, and a bit more feature-rich than your average DB2 or
Oracle, hasn't the history of Transactional Benchmarks on 64 X P5 big iron and
such, but is about as good as it gets for rock-solid on 'affordable' platforms.

DB2 and Oracle have more experience with clustering and massively parallel
operation - but those should not be an issue until the biz is doing well enough
to pay for that sort of migration.

Exim's load on PG should be the least of your worries!

Worst case - trigger an export on change to CDB for Exim, and it won't even
matter to the MTA if you have PG offline for maintenance / upgrade.

HTH,

Bill