<br><br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">
>> fill their mailbox, we would need to retrieve the quota usage of all<br>
>> those mailboxes. Unfortunately we still have legacy quota db (that is:<br>
>> one file per mailbox) on most platforms ... and migrating to other db<br>
>> formats is not always possible since some clients are very picky about<br>
>> the actions we do on 'their' platform ;)<br>
><br>
</div>> Tell you the truth, I like "legacy" quota DB. It reduces database<br>
> contention for quota updates. That said, it would be pretty trivial to<br>
> perform an in-place upgrade of quota data if we wanted to build something<br>
> good enough.</blockquote><div> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">We use logical quota for that. It is not RFC compliant (give a string to SETQUOTA command) but very useful. The real quota is defined at one place in imapd.conf. We can provide the patch if anybody is interested.<br>
</blockquote><div> <br></div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><div class="im">
>> Considering some backends do host hundreds of thousands of mailboxes,<br>
>> determining the quota usage of all users would be quite time consuming<br>
>> for us :)<br>
><br>
</div>> Well, yeah - it's a bit of IO. I don't know what sort of disk you have<br>
> those files on - we've got either SSD or fast RAID1 drives for our meta<br>
> partitions, so it's not too expensive to read a hundred thousand mailboxes<br>> (on the order of a few minutes).<br>
The choice was made to use NAS storage with lots of disks. Each NAS can host 1 to 2 millions mailboxes with some Cyrus above.<br></blockquote><div> </div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
> Too expensive to be run PER-MAILBOX. But running it once every 4 hours or<br>
> something to update a stats DB wouldn't be out of the question.<br>
<div class="im">Yeah. Crawling is our way to get mailboxes figures<br></div></blockquote><div> </div><br></div><br>