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
pgpCKpQlXIqcf.pgp
Description: PGP signature
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
