Sorry, for some reason I thought an earlier post said Postgresql, must be on the brain today. Good luck.
-- David A. Niblett | email: [email protected] Network Administrator | Phone: (352) 334-3400 Gainesville Regional Utilities | Web: http://www.gru.net/ -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of larrytek7 Sent: Tuesday, September 21, 2010 2:29 PM To: [email protected] Subject: Re: [Dbmail] Database Size (messageblks) Niblett, David A wrote: > > The only way you can usually get a Postgres DB table to go down to the > actual size of the data is to dump and restore. That's the point of a > database, it allocates space, marks unused space and overwrites that old > space with new data. This keeps the database from having to constantly > add and remove space. > > It's done a calculation and determined that that free row space you have > now is a good buffer amount. So you likely won't see the database grow > much (unless you start storing a lot more mail) or decrease in size > either. > > Unless you have some compelling reason to decrease the size, I wouldn't > worry about it. I think mine has been stuck at 37G for nearly 2 years > now. It just adds and deletes within the spare space. > I'm running mysql 5.0.84-r1 and I'm going to restore a dump from a backup to see if that helps. But I'm just curious about the major difference in size from messageblks and curmail_size. -- View this message in context: http://old.nabble.com/Database-Size-%28messageblks%29-tp29771510p29772348.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 _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
