I currently don't have postgresql-contribs installed, is it safe to install
that and run reindexdb? Or is there a risk of it messing up my database?
- Eric
From: Robert Claeson <[EMAIL PROTECTED]>
Reply-To: DBMail mailinglist <[EMAIL PROTECTED]>
To: DBMail mailinglist <[EMAIL PROTECTED]>
Subject: Re: [Dbmail] 2.2.2 slow
Date: Fri, 6 Apr 2007 18:31:29 +0200
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
_________________________________________________________________
Exercise your brain! Try Flexicon.
http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglineapril07
_______________________________________________
DBmail mailing list
[EMAIL PROTECTED]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
