Login | Register For Free | Help	Search this list this category for: (Advanced)

Mailing List Archive: DBMail: users emptying database   Index | Next | Previous | View Flat

pwadas at jewish Jun 17, 2009, 6:30 AM Views: 792 Permalink emptying database 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 DBmail[at]dbmail.org http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Subject User Time emptying database pwadas at jewish Jun 17, 2009, 6:30 AM     Re: emptying database pwadas at jewish Jun 17, 2009, 6:30 AM         Re: emptying database paul at nfg Jun 17, 2009, 6:33 AM             Re: emptying database pwadas at jewish Jun 17, 2009, 6:39 AM                 Re: emptying database paul at nfg Jun 17, 2009, 8:05 AM                     Re: emptying database vulture at netvulture Jun 17, 2009, 9:22 AM                         Re: emptying database mysql.jorge at decimal Jun 17, 2009, 9:35 AM                             Re: emptying database vulture at netvulture Jun 17, 2009, 9:58 AM                                 Re: emptying database mysql.jorge at decimal Jun 17, 2009, 10:41 AM                                 Re: emptying database paul at nfg Jun 18, 2009, 3:13 AM                 Re: emptying database vulture at netvulture Jun 17, 2009, 9:37 PM                     Re: emptying database pwadas at jewish Jun 17, 2009, 10:22 PM     Re: emptying database pwadas at jewish Jun 17, 2009, 11:18 PM     Re: emptying database vulture at netvulture Jun 18, 2009, 12:18 PM         Re: emptying database pwadas at jewish Jun 18, 2009, 12:25 PM         Re: emptying database paul at nfg Jun 18, 2009, 12:39 PM             Re: emptying database pwadas at jewish Jun 18, 2009, 10:18 PM     Re: emptying database vulture at netvulture Jun 18, 2009, 12:33 PM

Index | Next | Previous | View Flat   DBMail     users     dev

Interested in having your list archived? Contact lists@gossamer-threads.com
 

Web Applications & Managed Hosting Powered by Gossamer Threads Inc.