Re: Mail server load

From: Dennis Gearon <gearond(at)cvc(dot)net>
To: The Hermit Hacker <scrappy(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: Mail server load
Date: 2003-08-20 20:48:09
Message-ID: 3F43DE89.7050307@cvc.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

holy S**T!!

The Hermit Hacker wrote:

> 16:00 ...
>
> neptune# awk '{print $7}' /var/log/amavisd | sort | uniq -c
> 285 BAD
> 1807 BANNED
> 12289 INFECTED
> 11731 Passed,
> 5 SA
> 1 turned
>
> Here's a normal day:
>
> neptune# cat /var/log/amavisd.o | grep "Aug 17" | awk '{print $7}' | sort
> | uniq -c
> 332 BAD
> 13 BANNED
> 938 INFECTED
> 3792 Passed,
>
>
>
> On Wed, 20 Aug 2003, Tom Lane wrote:
>
>
>>"Nigel J. Andrews" <nandrews(at)investsystems(dot)co(dot)uk> writes:
>>
>>>Yesterday you had almost 1 for 1 valid email. By then I think I was getting
>>>about 3-4 per valid email but since then it's sky rocketed and it looks more
>>>like 30+ per 1 valid message.
>>
>>FWIW, this is what I see in traffic to an address I've had to abandon
>>because of spam:
>>
>> 488 Aug 8
>> 433 Aug 9
>> 435 Aug 10
>> 426 Aug 11
>> 504 Aug 12
>> 458 Aug 13
>> 469 Aug 14
>> 390 Aug 15
>> 433 Aug 16
>> 371 Aug 17
>> 520 Aug 18
>>36473 Aug 19
>>35808 Aug 20
>>
>>It's about 3pm local time here, so by midnight the stat for today will
>>probably be nearly double yesterday's total.
>>
>>The spam traffic had been around 2K/day at the beginning of the year,
>>but tapered off to around 500 as you see above. This spike is ten times
>>the highest I've seen before. If I were actually downloading this crap,
>>and not rejecting it at the SMTP handshake, my DSL line would be
>>saturated :-(
>>
>> regards, tom lane
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: Have you searched our list archives?
>>
>> http://archives.postgresql.org
>>
>
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-08-20 20:49:21 Re: Buglist
Previous Message Ron Johnson 2003-08-20 20:44:50 Re: Grouping by date range