[email protected] writes: > We see that I have 570292 message in my IMAP account. > But I have 570431 in all the folders because some message are in two > differents folders. > The used size on disk is 9993040 Kb. > But the approximated size, ie. the size of the 570431 messages, is 9999974 Kb. > > The new query you used is a good approximation of the exact size used, > > and we win 9 seconds (from 22,5 seconds down to 13,8 s).
That's still horribly slow; I'd like to have the result in 0.01s or so. Some clients like to do this whenever they open a mailbox, and that can be often. Even with the further improvements to 11s, we can't have opening a mailbox taking 11s. Do you think an estimate such as mymessages*totalsize/totalmessages can be done in 0.01? That needs to use the pg_this and pg_that tables, which is beyond me, but perhaps you or Abhijit know how to? Arnt
