Howdy folks, I'm running dbmail 3.2.3 on a postgresql db and am having slow inserts. About 2 seconds each. This is not really ok and it tends to get behind during peak usage or when someone emails every mailbox. I read that 2 seconds a message is not abnormal, can anyone confirm this?
My solution is to run balance (https://www.inlab.de/balance.html) to round robin postfix to 4 instances of dbmail-lmtp. I've been running it this way for a couple days and it looks like it is going to work. Does anyone else do it this way or see a reason for me not to run it this way? I did try to run dbmail-lmtp in stdin/stdout mode and call it from xinetd but the processes weren't ending like I expected and I ended up with a lot of them running and having file pointer errors eventually. Has anyone made it work with xinetd or inetd and can share the config with me? Not really related but my pg_dump backup is a little over twice the size of my db on disk. Is this normal or should I start worrying about that? Thanks Rich
_______________________________________________ DBmail mailing list DBmail@dbmail.org http://lists.nfg.nl/mailman/listinfo/dbmail