OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
Re: ways of reducing mysql load

From: Andre Tomt (andretomt.net)
Date: Mon Jul 19 2004 - 02:37:03 CDT


lst_hoe01kwsoft.de wrote:
> First : Postfix does exactly the lookups that are needed for it to work as
> expected. Due to modular design some lookups occur from multiple deamons.

Of course. I think I understand the architecture decently - my points
would break down in some setups. I'll see if the mentioned patch looks
usable, even though I will not use it before it becomes part of postfix
'mainline' as this setup will go production in not the too distant future.

> If you don't change your transport map frequently use a local hash-table.

This could be a viable option. The domain tables change fairly regularly
(50-100 times a day, maybe), but exporting the data using cron or a
custom daemon would probably do fine for now, even though its not
realtime. This would take care of relay_domains and transport_map (which
are my primary concerns right now) until a better solution possibly
comes by.

--
Cheers!
André Tomt