|
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 (andre
tomt.net)
Date: Mon Jul 19 2004 - 02:37:03 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
lst_hoe01
kwsoft.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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]