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. -- 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 1:52 PM To: [email protected] Subject: Re: [Dbmail] Database Size (messageblks) Jorge Bastos wrote: > > >>I'm in doubt, but I'm almost sure that the file size of my tables got fewer >>with an OPTIMIZE. >>It was it with a CHECK TABLE ? > > The table did decrease in size but only by less than 1GB. > > -- View this message in context: http://old.nabble.com/Database-Size-%28messageblks%29-tp29771510p29771993.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
