Re: Postfix + MySql - reducing queries?

specify virtual_alias_domains (and virtual_alias_maps) in main.cf
or in a local file.

Some lookups will happen anyway, because the SMTP server needs
to reject mail for a non-existent address, and other parts of Postfix
need the same information too.

Wietse

Nikolas Hagelstein:
> Hi,
>
> i am running a mysql(4.xx)/postfix(2.0.16)/amvis combination.
> The setup is almost identical to the one described
> in "FILTER_README - Squeezing out more performance".
>
> i am surprised about that much (mostly redundant ones) sqlquerys
> being necessary. Did i missed something? Any optimisation hints?
>
> Regards,
> niko
>
> Query log:
> [SMTPD]
> 3490 Query select goto from alias where address = 'user@mydomain'
> 3490 Query select goto from alias where address = '@mydomain'
> 3491 Query select maildir from mailbox where address = 'user@mydomain'
> [pre cleanup ?!]
> 3490 Query select goto from alias where address = 'user@mydomain'
> 3490 Query select goto from alias where address = '@mydomain'
> 3491 Query select maildir from mailbox where address = 'user@mydomain'
> 3488 Query select goto from alias where address = 'mydomain'
> 3489 Query select description from domain where domain = 'mydomain'
>
> [amavis policy query -> removed]
>
> [reinjektion to cleanup]
> 3488 Query select goto from alias where address = 'mydomain'
> 3489 Query select description from domain where domain = 'mydomain'
> 3493 Connect maildbuser@localhost on maildb
> 3493 Query select goto from alias where address = 'user@mydomain'
> 3493 Query select goto from alias where address = '@mydomain'
> 3494 Connect maildbuser@localhost on maildb
> 3494 Query select maildir from mailbox where address = 'user@mydomain'
> 3495 Connect maildbuser@localhost on maildb
> 3495 Query select goto from alias where address = 'user@mydomain'
> 3495 Query select goto from alias where address = '@mydomain'
> 3496 Connect maildbuser@localhost on maildb
> 3496 Query select maildir from mailbox where address = 'user@mydomain'
>
>
>
>
>