Hashing database files?

[Bill Earle]

On Fri, 24 Oct 2003, Rob Siemborski wrote:

> On Fri, 24 Oct 2003, Bill Earle wrote:
>
> > - I hope this isn't the case.
>
> Why not?

We are having contention problems with a single file and the multiple
files may help.

In our current config., deliverdb uses about 12 GB spread across our
backends. This is version 2.0.16 and hashed deliver db's and we see
no performance problems with 104 total files. (26 * 4)


> > What configure option or patch is required to has the deliverdb's?
> > Will hashing work with all 2 types of databse files, flat, DBD
> > and skiplist?
>
> There isn't any.
>
> > Has anyone done this with mailboxes.db?
>
> This would probably be a really bad idea, given the way that mailboxes.db
> is accessed.

Is there a good document that describes how mailboxes.db and others are
accessed?


- Bill


> > Would the configure option --enable-fulldirhash have any effect
> > on the db's?
>
> No.
>
> -Rob
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Rob Siemborski * Andrew Systems Group * Cyert Hall 207 * 412-268-7456
> Research Systems Programmer * /usr/contributed Gatekeeper
>