On Sat, Aug 09, 2008 at 08:35:28PM +0300, Ibrahim Harrani wrote: > \> Good. > > > >> What about the PgSQLConnectionCache value? I set it 30.. > >> > > This value should be set to the number of simultaneous DSPAM checks that > > you plan to run. Are you using the dspam server daemon/dspamc? > I am using the dspam server at daemon mode > > > >> By the way, I recognized that, While I am training dspam, total > >> process time increases from 0.3-0.4 seconds to 5-10 seconds. > >> > > Do you mean that it takes 5-10 seconds per message? > Yes, It takes 5-10 seconds per message. > > > >What version of DSPAM did you say that you were using? > # dspam --version > > DSPAM Anti-Spam Suite CVS (agent/library) > > > Do you have slow query logging enabled? If not, turn it on and run "EXPLAIN > > ANALYZE query" for some > > typical slow queries. They should all be using indexes and not > > sequential scans. > No, I did not enable slow query logging, I will do and inform you. > Also, since you are running PostgreSQL 8.3 you can turn off synchronous commit. This should give you a nice performance boost as well, similar to turning off fsync but the DB is consistant and healthy if power is lost. You may lose an update, but the database will still be okay.
Ken !DSPAM:1011,489dec3d150922063715267!
