[Sqlgrey-users] Performance with Postfix and SQLGrey

[Dave S. <dst...@ma...>]

I am seeing, under the load of about 1,000 Postfix connections per minute, =
SQLGrey slow down. Note the times here in the log below. The email is seen =
by Postfix at 10:44, but not finished and ready to send for about 30 =
seconds. I have about 350 threads open on this server, and they are =
typically all in play. The LA is fairly low (3 to 4).
=20
Is this SQLGrey that's slowing things down? It has to spawn a lot of =
sessions (see the stats above). Or is it our Postgres DB that's slowing =
this down?
=20
Feb 12 12:10:44 ib17 postfix/smtpd[14833]: 5E9FE1D3A481: client=3D{removed}=
[{removed}.99]
Feb 12 12:10:44 ib17 postfix/cleanup[15475]: 5E9FE1D3A481: message-id=3D<7F=
A493658BF13544BCDD9CF41F9BFC01BB5068@{removed}.com>
Feb 12 12:10:45 ib17 postfix/qmgr[14681]: 5E9FE1D3A481: from=3Djsmith@{remo=
ved} ( mailto:from=3Dlsegesvary@removed ).com, size=3D34936, nrcpt=3D2 =
(queue active)
Feb 12 12:11:13 ib17 postfix/smtp[16934]: 5E9FE1D3A481: to=3D<kwilson@{remo=
ved}.com ( mailto:kw...@re... )>, relay=3D{removed}[{removed}.27], =
delay=3D34, status=3Dsent (250 Ok: queued as 27A6A5FB6723)
=20
TIA,
=20
=20
=20
=20
Dave Strickler
MailWise LLC
617-933-5810 (direct)
www.mailwise.com ( http://www.mailwise.com/ )
"Intelligent E-mail Protection"




This message has been certified virus-free by MailWise Filter - The real-ti=
me, intelligent, e-mail firewall used to scan inbound and outbound messages =
for SPAM, Viruses and Content. =0A=0A  For more information, please visit: http:=
//www.mailwise.com=0A