On Fri, May 25, 2001 at 08:49:21PM +0000, Terry Lambert wrote:
> There is _no_ performance problem with "the existing implementation",
> if you treat "postgres" as "the existing implementation"; it will do
> what you want, quickly and effectively, for millions of record keys.
Does postgres make a good mail archive database? Can it handle
arbitrary record lengths? It couldn't the last time I looked at
it.
> Why are you treating an FS as if it were a relational database? It
> is a tool intended to solve an entirely different problem set.
I'm not treating it as a relational database. But if mail
messages aren't conceptually "files", then I don't know what
they are.
One of my personal mail folders has 4400 messages in it, and
I've only been collecting that one for a few years. It's not
millions, but its a few more than the "500" that I've seen some
discuss here as a reasonable limit (why is that reasonable?) and
it's many many more than the 72 or so limit available in ADFS.
I changed over to Maildirs becuase I like the fact that I
can use normal Unix file search and manipulation programs on
individual messages, as well as a wider set of MUAs (thanks
to courier IMAP...), and because folder opening doesn't bog
down when there are a couple of messages with really large
attachments in them, the way mbox folders do.
> You are bitching about your hammer not making a good screwdriver.
If the file system isn't a good place to store files, then what
is it good for?
Souce code trees only?
There are application specific databases available for that too.
What have you got left?
--
Andrew
To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-hackers" in the body of the message