>>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 -- ## 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/
