Hello, I have one user on new installation of dbmail 2.3.5 on postgres 8.3.x. I started with empty database (1-5MB total database size). Then, I put 200 messages (100MB), into his mailbox (inbox), then I deleted them, then, I did dbmail-util -d -p etc. etc., then I did some vacuuming on pg, etc. etc. Database still have about 86MB, although the messages are gone from the mailbox. The biggest table (almost total of these 86mb) is dbmail_mimeparts. So, what's going on? I expected the database approx. similar to original size..
Regards, P. server:~# dbmail-util -ay Repairing DBMAIL messageblocks integrity... Ok. Found [0] unconnected messageblks. Repairing DBMAIL physmessage integrity... Ok. Found [0] unconnected physmessages. Repairing DBMAIL message integrity... Ok. Found [0] unconnected messages. Repairing DBMAIL mailbox integrity... Ok. Found [0] unconnected mailboxes. Repairing DBMAIL for NULL messages... Ok. Found [0] NULL messages. Deleting messages with DELETE status... Ok. Messages deleted. Repairing DBMAIL for rfcsize field... Ok. Found [0] missing rfcsize values. Repairing DBMAIL for incorrect is_header flags... Ok. Found [0] incorrect is_header flags. Repairing DBMAIL for cached envelopes... Ok. Found [0] missing envelope values. Repairing DBMAIL for cached header values... Ok. Found [0] un-cached physmessages. Setting DELETE status for deleted messages... Ok. Messages set for deletion. Re-calculating used quota for all users... Ok. Used quota updated for all users. Removing aliases with nonexistent delivery userid's... Ok. Found [0] dangling aliases. Vacuuming and optimizing database... Ok. Database cleaned up. Maintenance done. No errors found. -- View this message in context: http://www.nabble.com/emptying-database-tp24067701p24067701.html Sent from the dbmail users mailing list archive at Nabble.com. _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
