What would selecting those rows even do, wouldnt I want to delete those rows?
VACUUM FULL VERBOSE would freeze the database correct?
I have gone through and added alot of the new additions to the schema to see if
that helps speed it up. I know how to reindex one index, is there a way to
reindex all indexes?
> From: [EMAIL PROTECTED]
> To: [email protected]
> Subject: Re: [Dbmail] Restore DB & get better performance
> Date: Mon, 17 Sep 2007 01:09:41 +0200
>
> On Sonntag, 16. September 2007 23:20 Eric Hiller wrote:
> > QUERY PLAN
> > Total runtime: 42115290.134 ms
> > Thats right, nearly 12 hours!
>
> It could be that your values for the ANALYZE commands in the config are
> not correct, or it really takes so much time because you NEVER executed
> that command before. How many message are there overall? So you could
> see about how many messages would be deleted. If it's more than 20%,
> you should really execute it (maybe on a weekend), to get the index
> smaller. Make a VACUUM FULL VERBOSE afterwards, to see the improvement.
>
> > Should I go through the database and just delete all the indexes and
> > constraints and then re add them?
>
> I've never done that. There's the REINDEX command, so you don't have to
> delete & add. I'd try this.
>
> > Since it is 8.2 autovacuum does not appear in the log? How can I even
> > tell if the autovacuum is running correctly?
>
> Sorry I have 8.1, and see it in the logs. I'd suggest:
>
> - delete unused messages (either with the command you ANALYZEd, or by
> upgrading dbmail to 2.2.6 and running dbmail-util -ay)
> - VACUUM FULL, if a lot of deletes happened
> - REINDEX, if you feel the need
>
> I'm no DB expert, that's just what I would do.
>
> mfg zmi
> --
> // Michael Monnerie, Ing.BSc ----- http://it-management.at
> // Tel: 0676/846 914 666 .network.your.ideas.
> // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import"
> // Fingerprint: EA39 8918 EDFF 0A68 ACFB 11B7 BA2D 060F 1C6F E6B0
> // Keyserver: www.keyserver.net Key-ID: 1C6FE6B0
_________________________________________________________________
Gear up for Halo® 3 with free downloads and an exclusive offer. It’s our way of
saying thanks for using Windows Live™.
http://gethalo3gear.com?ocid=SeptemberWLHalo3_WLHMTxt_2
_______________________________________________
DBmail mailing list
[email protected]
https://mailman.fastxs.nl/mailman/listinfo/dbmail
