What database to choose for production deployment: Postgres or MySql
Hi,
What database is better for large deployment: Postgres or MySql? 'Large' means
- around 15k mailing lists
- 36k incoming messages per day
- 270k outgoing messages per day distributed to recipients
Is there preference from performance point of view? Or something else worth mentioning?
Thanks, Paweł
On 6/18/20 11:54 AM, pgrzywaczewski@gmail.com wrote:
What database is better for large deployment: Postgres or MySql? 'Large' means
- around 15k mailing lists
- 36k incoming messages per day
- 270k outgoing messages per day distributed to recipients
Is there preference from performance point of view? Or something else worth mentioning?
We came across a bug using MySQL with Mailman 3 but I can't remember the specifics. I have done a number of installations using Postgres with NO PROBLEMS so my recommendation is Postgres.
-- Please let me know if you need further assistance.
Thank you for your business. We appreciate our clients. Brian Carpenter EMWD.com
-- EMWD's Knowledgebase: https://clientarea.emwd.com/index.php/knowledgebase
EMWD's Community Forums http://discourse.emwd.com/
Thanks,
What was the largest installation that you have done? Have you done some performance tests?
Cheers, Pawe
Brian Carpenter writes:
We came across a bug using MySQL with Mailman 3
I recall a problem reported that MySQL does not apply ordering to subqueries (this is conformant to the SQL standard, but other SQL databases, specifically Postgres and SQLite3 *do* apply ordering), and this resulted in subscriber lists that weren't alphabetized. Maybe that was your developer for Affinity who reported it?
I'm not sure if we fixed this in Mailman, and I don't think it's a problem for Postorius, only for direct access to the REST API.
Pawel,
I've used m5*large and c5*large in my installations. Hot spot areas - mailman list operations (update,add,create) for subscribers. ~100 lists, > 500k daily send
participants (4)
-
Brian Carpenter -
pgrzywaczewski＠gmail.com -
Stephen J. Turnbull -
sunil soprey