BLU Discuss list archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Discuss] Stalwart E-mail; Was: Re: SSH options
- Subject: [Discuss] Stalwart E-mail; Was: Re: SSH options
- From: ron at bclug.ca (Ron)
- Date: Sat, 24 Jan 2026 18:11:50 -0800
- In-reply-to: <20260124185320.628bb1f8@mydesk.domain.cxm>
- References: <61c91e0a-f658-415c-a91d-bc8cb008bf0b@borg.org> <26989.37879.578151.953291@gargle.gargle.HOWL> <26989.37936.100241.254462@gargle.gargle.HOWL> <c40fd68e-e540-471c-a253-7ae04dedaa65@borg.org> <20260119080150.7891b97d.Richard.Pieri@gmail.com> <56dcf563-62a6-4c16-aa84-ed825818def7@borg.org> <987cd7dc-096a-4a4c-be90-20e4847cdb17@bclug.ca> <20260120162647.1d90d2d7@mydesk.domain.cxm> <32eaffac-42e5-4af7-9fae-8a0514d9b97d@bclug.ca> <20260120215709.4cd9c226.Richard.Pieri@gmail.com> <96abce57-0162-4309-aa2e-a508b824c2c7@bclug.ca> <20260122110203.21ec8565.Richard.Pieri@gmail.com> <4fbd5345-e753-4fe5-8632-231ce29a362b@bclug.ca> <20260124185320.628bb1f8@mydesk.domain.cxm>
Steve Litt wrote on 2026-01-24 15:53: >> the thought of billions (or millions) of Maildir files per day is >> laughable. > > The preceding sentence is an ad homonym logical fallacy. I don't think you know what "ad hominem" means. Maybe not even "logical fallacy". > It's your opinion, which might be right, might be wrong, or might be > "it depends". You dispute that massive quantities of small files can cause issues with various (not necessarily all) file systems? What about exhausting the inode count? Is that yet another factor to consider when running a large mail server? Besides being "my opinion", anyone who's actually done this and isn't operating on feelings seems to think a DB is the way to go. See "Gmail". > To me the dead bang obvious course of action is to keep emails in > individual files, in a directory tree so that no single subdirectory > contains more than 1000 files Have you never seen a mailbox before? Having over 1000 messages in an Inbox folder is probably more common than not. Arbitrarily splitting a mailbox into multiple sub-directories is just another layer of complexity that doesn't solve anything. Gmail doesn't even have folders, it has a representation of folders via labels. I don't like it, but that means every Gmail user basically has all their messages in one folder. What you find "dead bang obvious" has been rejected by those who actually do the thing. > and then keep a copy of the email's subject, date, to, from, cc, > bcc, List-ID and full pathname of the email in a relational database > like Postres or MariaDB. If you're going that far into a DB, keep the message body there too. Maybe the attachments can be separate, but why bother at this stage, a RocksDB record is *recommended* to not exceed 3GB which is a pretty large email: > Q: What's the maximum key and value sizes supported? > > A: In general, RocksDB is not designed for large keys. The maximum > recommended sizes for key and value are 8MB and 3GB respectively. https://github.com/facebook/rocksdb/wiki/RocksDB-FAQ > Now you can lightning quick look up by all major headers, but still > have the email message stored as an email file readable from any > email client. Email clients don't have any concept of storage on the server - whether the messages are mbox, Maildir, or a DB. Why would an "email client" ever try to read storage directly on the server? > If you simply *must* be able to search bodies "If" is extraneous. People *must* be able to search message bodies. That is non-negotiable.
- References:
- [Discuss] Future of X11 (was Trying to connect to internet in Debian)
- From: kentborg at borg.org (Kent Borg)
- [Discuss] SSH options (was Future of X11 (was Trying to connect to internet in Debian))
- From: dbarrett at blazemonger.com (Daniel Barrett)
- [Discuss] SSH options (was Future of X11 (was Trying to connect to internet in Debian))
- From: kentborg at borg.org (Kent Borg)
- [Discuss] SSH options (was Future of X11 (was Trying to connect to internet in Debian))
- From: richard.pieri at gmail.com (Rich Pieri)
- [Discuss] SSH options (was Future of X11 (was Trying to connect to internet in Debian))
- From: kentborg at borg.org (Kent Borg)
- [Discuss] SSH options (was Future of X11 (was Trying to connect to internet in Debian))
- From: ron at bclug.ca (Ron)
- [Discuss] SSH options (was Future of X11 (was Trying to connect to internet in Debian))
- From: slitt at troubleshooters.com (Steve Litt)
- [Discuss] SSH options (was Future of X11 (was Trying to connect to internet in Debian))
- From: ron at bclug.ca (Ron)
- [Discuss] SSH options (was Future of X11 (was Trying to connect to internet in Debian))
- From: richard.pieri at gmail.com (Rich Pieri)
- [Discuss] SSH options (was Future of X11 (was Trying to connect to internet in Debian))
- From: ron at bclug.ca (Ron)
- [Discuss] Stalwart E-mail; Was: Re: SSH options
- From: richard.pieri at gmail.com (Rich Pieri)
- [Discuss] Stalwart E-mail; Was: Re: SSH options
- From: ron at bclug.ca (Ron)
- [Discuss] Stalwart E-mail; Was: Re: SSH options
- From: slitt at troubleshooters.com (Steve Litt)
- [Discuss] Future of X11 (was Trying to connect to internet in Debian)
- Prev by Date: [Discuss] Stalwart E-mail; Was: Re: SSH options
- Next by Date: [Discuss] Stalwart E-mail; Was: Re: SSH options
- Previous by thread: [Discuss] Stalwart E-mail; Was: Re: SSH options
- Next by thread: [Discuss] SSH options (was Future of X11 (was Trying to connect to internet in Debian))
- Index(es):
