>>On 2009-05-06 18:05, Martin A. Brooks wrote:
>>Peter Kirk wrote:
>> Any other ideas how I can clean out this database a bit?
>>.
>>
>> More a postgres question this, but what do you mean by "clean out"?
>> 200M is _titchy_, what makes you think you need to manually vacuum
>>the
>> database in the first place? Unless you're using very old, or very
>> badly configured, postgres, the internal autovacuumer will be
>> maintaining tables for you.
>>
>>
>>
>You can delete after a few days the records for senders who did not
>retry. Run a cron script for this.
>Peter
>--
>## List details at http://lists.exim.org/mailman/listinfo/exim-users
>## Exim details at http://www.exim.org/
>## Please use the Wiki with this list - http://wiki.exim.org/
Hey
Sorry thought it was progress but ends up it's spamassasin that is using
all the cpu... though on the progresql part, I do have to vacuum the
database ever few months and do notice a increase performance.
So any thoughts on the spamassassin using all the cpu
