should be fine. It's just a shell script or program that invokes standard PostgreSQL SQL statements.
LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683 E-Mail: [EMAIL PROTECTED] US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Eric Hiller Sent: Thursday, April 12, 2007 10:48 AM To: [EMAIL PROTECTED] Subject: Re: [Dbmail] 2.2.2 slow 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_hmemailtaglineapr il07 _______________________________________________ DBmail mailing list [EMAIL PROTECTED] https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [EMAIL PROTECTED] https://mailman.fastxs.nl/mailman/listinfo/dbmail
