(Postgresql) SQL stuff to deal with folders & folder counts

Thomas Raschbacher <[email protected]> Thu, 01 Mar 2018 08:33:48 +0100

Newsgroups	gmane.mail.imap.dbmail
Message-ID	<[email protected]>

Hi.

I had to do some optimizing of a user's mailboxes, so i wrote some 
useful SQL:

https://blog.lordvan.com/blog/dbmail-quickly-get-mailbox-counts-including-deleted-emails-postgresql/

I assume that MySQL or oracle syntax would be a bit different (do they 
have FILTER ? no idea.. )
But maybe this is useful for someone else.
also that VIEW is very handy to quickly get an idea of folder message 
counts :)

Regards

_______________________________________________
DBmail mailing list
[email protected]
http://lists.nfg.nl/mailman/listinfo/dbmail

signature.asc (application/pgp-signature, 833 B)