Re: curmail_size vs innodb disk usage

On Fri, Mar 20, 2015 at 9:31 AM, Reindl Harald <[email protected]>
wrote:

>
> Am 19.03.2015 um 21:16 schrieb Simon:
>
>> What im trying to understand is why is the SUM of curmail_size is approx
>> 110GB, yet the database size (even dump'ed) is 400GB. Surely dbmail does
>> not have that much overhead in its database?
>>
>
> mailsize has barely to do with database size
> completly different worlds
>
> no database at all gives back space just because data are removed because
> the overhead would be way too large, be it mysql, berkely db, postgresql or
> something else - they all try to re-use allocated space as good as possible
> without vacuum all the time
>

OK thanks for the clarification on this. I just seems completely out of
wack that the DB would use 4 times the amount of space for the actual data
to me :)

One of the reasons we have moved away from dbmail for our primary
platform...

Simon

_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail