On Wed, 2009-07-22 at 11:04 -0500, Noel Jones wrote: > Clunk Werclick wrote: > > I think perhaps 4-12 queries per message is not optimal? > > If server handle 50,000 a day X 12 that is quite a lot? I don't think > > it is going to get may fields returned for .co.uk .uk in my database? > > > > Postfix does the lookups required to route your mail properly. It is a bit silly to do this for .co.uk then .uk yes? > > > I stress much that this is not Postfix, it is my silly configuration of > > Postfix. Am learning as I go along so plenty of things wrong probably: > > > > This is output; > > > > postconf -n > > relay_domains = mysql:/etc/postfix/mysql/relay_domains.cf > > Unless relay_domains changes frequently, better to keep it in > a hash table. Or just set it explicitly empty if you don't > have any relay_domains.
They change frequently that is why I have a database back end. > > transport_maps = mysql:/etc/postfix/mysql/transport.cf > > better to keep transport_maps in a hash: table unless it > changes frequently. > > > virtual_mailbox_domains = mysql:/etc/postfix/mysql/virtual_domains.cf > > better to keep virtual_mailbox_domains in a hash table unless > it changes frequently. They change frequently that is why I have a database back end. > > For the tables that I suggest you keep in a hash, if you want > to still store the data in mysql you can automate a daily dump > to a hash file for postfix to use. This seems to be a bit silly, that is what the database is for, but thank you for your advice. I may have to do this to stop this DoS type of hammering for silly lookups. Thank you anyhow. > > > -- Noel Jones -- ----------------------------------------------------------- C Werclick .Lot Technical incompetent Loyal Order Of The Teapot. This e-mail and its attachments is intended only to be used as an e-mail and an attachment. Any use of it for other purposes other than as an e-mail and an attachment will not be covered by any warranty that may or may not form part of this e-mail and attachment.
