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
