On Fri, 26 Mar 2010, Martin Svensson wrote:
As I mentioned in my first email the total number of email/day hasn't changed and the config is the same. We even wiped the whole bayes database and within 12 hours the I/O wait and average load on the database server were much higher than usual - and 12 hours of bayes data isn't that many rows.
My first response to those symptoms as a DBA is to ask, is there a missing (or disabled) index? It sounds like full table scans rather than proper indexed lookups.
-- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ jhar...@impsec.org FALaholic #11174 pgpk -a jhar...@impsec.org key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- A sword is never a killer, it is but a tool in the killer's hands. -- Lucius Annaeus Seneca (Martial) 4BC-65AD ----------------------------------------------------------------------- 168 days since President Obama won the Nobel "Not George W. Bush" prize
