On 6 Apr 2007, at 17:45, Eric Hiller wrote:
When running top, the postmaster process is what takes up all the cpu.
I ran the vacuumdb last night, and that decreased the load time of
a message from 5+ seconds to 2+ seconds, still pretty long though.
You may want to also run reindexdb on the database. If the indexes
becomes too unbalanced, the optimiser in the database may decide to
use table scans rather than index scans, which can consume a lot of
CPU. This is in fact true for all relational databases.
Robert
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
