Skip to Main Content

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Selecting an extent size for Queues

530582Aug 29 2006 — edited Aug 29 2006
Hi,

Has anyone got experience in selecting an extent size for BDB Queue toplogy databases? I'm trying to pick an extent size for a database and have come to the conclusion that throughput of data through the queue is a good guide when selecting an extent size. I.e. make your extent size proportional to the amount of data which moved through the queue. For example: Assuming you're not too worried about disc space, for a queue with 50MB of data throughput pick an extent size of 10MB.

Has anyone got any ideas whether this approach is sound?

The technical reference makes the following statement, which although accurate isn't very helpful:

In choosing an extent size there is a tradeoff between the amount of disk space used and the overhead of creating and deleting files. If the extent size is too small, the system will pay a performance penalty, creating and deleting files frequently. In addition, if the active part of the queue spans many files, all those files will need to be open at the same time, consuming system and process file resources.

Regards, Sebastian.

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 26 2006
Added on Aug 29 2006
1 comment
943 views