On Donnerstag, 12. Juli 2007 Aleksander Kamenik wrote: > There also are no 20k messages set for deletion nor purging. Is it > possible that these messages were left hanging? dbmail-util -ay > didn't find anything wrong.
Yes, I've had long discussions about this in a previous thread. You can now do: DELETE FROM dbmail_physmessage WHERE id NOT IN (SELECT physmessage_id FROM dbmail_messages); This will save you lots of space *g* To prevent such leftover physmessages in the future, I've developed this RULE with the help of others, for postgres: CREATE RULE drop_messages_with_mailbox AS ON DELETE TO dbmail_messages DO DELETE FROM dbmail_physmessage WHERE id = OLD.physmessage_id AND id NOT IN (SELECT physmessage_id from dbmail_messages); 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
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
