Re: [Sks-devel] 3 million keys & and community help requested

[John Clizbe]

Kim Minh Kaplan wrote:
> John Clizbe wrote:
> 
>> Are we using the most efficient schema for the database? Page sizes and other
>> default DB creation settings and tunables?
> 
> I have started running some benchmarks. First results are available at
> <https://www.kim-minh.com/pub/sks/sks-database-tuning>. The short
> answer is that we are probably not using a good page size.


GREAT work! Thank you, Kim.

The only tuning I found on PTree was increasing the page size to 8192 greatly
reduced the number of mutex locks (1/page) required. I was experiencing
deadlocks running out of available mutexes during pbuild.

Best Regards,

-John