Re: [Sqlgrey-users] slow performance

[Beast <be...@i6...>]

Lionel Bouton wrote:
> 
> 
> This is normal. Could you post the output of 'postconf -n'? As SQLgrey's
> only time consuming operations are SQL queries, I suspect something
> other in your Postfix configuration is causing this. If you take SQLgrey
> out of the loop is the answer from Postfix after "RCPT TO:" noticeably
> quicker ?
> 

This is related config in main.cf

smtpd_recipient_restrictions =
   reject_non_fqdn_recipient,
   permit_mynetworks,
   reject_unauth_destination,
   reject_unknown_recipient_domain,
   check_sender_access hash:/etc/postfix/sender_access,
   check_client_access hash:/etc/postfix/client_access,
#  reject_rbl_client relays.ordb.org,
#  reject_rbl_client sbl.spamhaus.org,
#  reject_rbl_client bl.spamcop.net,
#  reject_rbl_client sbl-xbl.spamhaus.org,
#  reject_rbl_client opm.blitzed.org,
#  reject_rbl_client list.dsbl.org,
#  reject_rbl_client dul.dnsbl.sorbs.net,
### sqlgrey
   check_policy_service inet:127.0.0.1:2501
   permit


If I comment check_policy_service, then the response is quicker (arround 
1 sec, with sqlgrey _always_ 15-20 sec).


-- 

--beast