On Montag, 28. Januar 2008 Paul J Stevens wrote: > That smells like POP3 access. Like Marc's suggestion, perhaps we > should offer a pop3-storage only mode (no headercaching, no envelope > caching, etc). But that would not be possible on a per-user basis, > only on a per-dbmail-instance basis. Not without changing the > delivery chain very significantly. Sorry Marc.
Where is Marc's suggestion? Is it because POP3 is the quicker protocol? I thought about IMAP because it's designed for server stored messages, but I have no preference anyway so I don't bother. The server of course has to do some nightly garbage collection: delete old spams that are older than, say, 50 days. That would mean the user doesn't care anyway. What I see as an important feature of dbmail is the "space saving storage" where one attachment is stored only once. Is there a name for that feature already? > Yes. A pop3 delivery mode could easily be done with a couple of > #ifdef's in the code. If that works out and people like/use it, > making it a run-time config option becomes trivial. Sounds like big fun. Yes, that could be very nice. > Yes. But 1k messages per second insertion is still quite a lot. It > would still require something like 10 or 15 queries with around 7 or > 8 insert/update queries for simple non-multipart messages. And 10-15k > queries per second is still quite a lot in my experience. Hell, I've > setup mysql-clusters which did 2000k queries per second sustained > without breaking a sweat so it should be within reach for postgres. > But ymmv. As I need 10TB storage anyway, that would be a big amount of SAS disks on very nice RAID controllers. I was just wondering about some really big installations and how much I/O they manage with what hardware. If I don't hear anything, we'd have to test it, which is not easy (nobody has 10TB disk storage laying around...). mfg zmi -- // Michael Monnerie, Ing.BSc ----- http://it-management.at // Tel: 0676/846 914 666 .network.your.ideas. // PGP Key: "curl -s http://zmi.at/zmi.asc | gpg --import" // Fingerprint: AC19 F9D5 36ED CD8A EF38 500E CE14 91F7 1C12 09B4 // Keyserver: www.keyserver.net Key-ID: 1C1209B4
signature.asc
Description: This is a digitally signed message part.
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
