Re: Speeding up Local Delivery

2010-01-14 Thread Wendigo Thompson
Victor: I wanted to use Postfix as a delivery mechanism so that I would be able to queue and hold mail during database outages and other maintenance -- a job that it does very well. Is there really no advice available on how to increase the speed of Postfix's local mail delivery? Thanks,

Re: Speeding up Local Delivery

2010-01-14 Thread Wietse Venema
Wendigo Thompson: Victor: I wanted to use Postfix as a delivery mechanism so that I would be able to queue and hold mail during database outages and other maintenance -- a job that it does very well. Is there really no advice available on how to increase the speed of Postfix's local mail

Re: Speeding up Local Delivery

2010-01-14 Thread Wendigo Thompson
Wietse: I know who you are -- big fan of yours ever since tcpwrappers :-) The only reason I wrote in is that this queueing of mail issue appeared fairly recently, and other times when I have had to collect large volumes of mail from this client my system has been fine. Below I have pasted

Re: Speeding up Local Delivery

2010-01-14 Thread Wietse Venema
Wendigo Thompson: Wietse: I know who you are -- big fan of yours ever since tcpwrappers :-) Hah! (As for my claim, of course other people also wrote parts of Postfix, in particular Victor has been a major contributor). The only reason I wrote in is that this queueing of mail issue

Re: Speeding up Local Delivery

2010-01-14 Thread Wendigo Thompson
Wietse: Sadly I generally don't keep logs at this granular of a level (mail.crit is what I usually store forever) but I can turn logging back on after the queue empties over the weekend and see if the delay is persisting. I know the command itself is completing quickly -- it seems like

Re: Speeding up Local Delivery

2010-01-14 Thread Wietse Venema
Wendigo Thompson: Wietse: Sadly I generally don't keep logs at this granular of a level (mail.crit is what I usually store forever) but I can turn logging back on after the queue empties over the weekend and see if the delay is persisting. I know the command itself is completing quickly

Re: Speeding up Local Delivery

2010-01-14 Thread Wendigo Thompson
Okay, I have some updates. Reducing the concurrency down (and ultimately to 1) increased performance: it seems the delays I was seeing were related to concurrency inside SQL. However, I am still seeing half second delays in local delivery while my insertion application is showing ~.003s

Re: Speeding up Local Delivery

2010-01-14 Thread Stan Hoeppner
Wendigo Thompson put forth on 1/14/2010 6:39 PM: Okay, I have some updates. Reducing the concurrency down (and ultimately to 1) increased performance: it seems the delays I was seeing were related to concurrency inside SQL. However, I am still seeing half second delays in local delivery

Re: Speeding up Local Delivery

2010-01-14 Thread Wietse Venema
Wendigo Thompson: Okay, I have some updates. Reducing the concurrency down (and ultimately to 1) increased performance: it seems the delays I was seeing were related to concurrency inside SQL. However, I am still seeing half second delays in local delivery while my insertion application is

Re: Speeding up Local Delivery

2010-01-13 Thread Victor Duchovni
On Wed, Jan 13, 2010 at 12:35:19AM -0600, Wendigo Thompson wrote: Postfix accepts mail from the corporate mail server and delivers the message via a pipe alias to an application that is then inserting the message into the database. Your choice of delivery mechanism is unfortunate. It is far

Speeding up Local Delivery

2010-01-12 Thread Wendigo Thompson
Hello: I maintain for a large client a Postfix/MySQL installation that archives certain messages required to be held for compliance with lawsuits and employment litigation. Postfix accepts mail from the corporate mail server and delivers the message via a pipe alias to an application that is