On Sat, Apr 18, 2020, at 8:25 AM, skenny@scss.tcd.ie wrote:
Well, it is quite possible that something is seriously wrong with my configuration.
The database backend is Postgres - not something I configured. It is specified in my docker-compose file, which in turn is based on the compose files at https://github.com/maxking/docker-mailman.
(At one point I thought maybe the virtual machine I'm running on was under-resourced. I've since doubled memory and the number of CPUs but that hasn't really improved things.)
I'm wondering where to go next - try tweaking the Postgres config, switch to SQLlite ....
Switching to SQLite will definitely degrade performance, unless Postgres database is being weird. I haven't observed any issues reported in the past for the performance.
I am a little confused which part are we talking here about being too slow. You mentioned two things:
- The python script you wrote using MailmanClient
- Listing non-members/members
- Delete a non-member via Postorius.
It would be nice to establish which specific view is being slow so I can dig more into it. Can you paste the URL and action which takes 2.5minutes as you mentioned?
Thanks for giving time to helping me with this, much appreciated.
Stephen
Mailman-users mailing list -- mailman-users@mailman3.org To unsubscribe send an email to mailman-users-leave@mailman3.org https://lists.mailman3.org/mailman3/lists/mailman-users.mailman3.org/
-- thanks, Abhilash Raj (maxking)