News for hackers. Stuff that matters.

A comment on Are You Sure You Want to Use MMAP in Your Database Management System?. Parent comment

Re:Are You Sure You Want to Use MMAP in Your Database Manage... by ori_b on Sunday July 02, 2023 @08:33PM (#36567333)
Do you have benchmarks of lmdb when the working set is much larger than memory?

mmap works fine with small working sets.

[ Parent | on HN ]
Re:Are You Sure You Want to Use MMAP in Your Database Manage... by hyc_symas on Sunday July 02, 2023 @09:06PM (#36567522)
> Do you have benchmarks of lmdb when the working set is much larger than memory? I couldn't find any.

Where did you look? This is a sample using DB 5x and 50x larger than RAM http://www.lmdb.tech/bench/hyperdex/

There are plenty of other larger-than-RAM benchmarks there.

[ Parent | on HN ]
Re:Are You Sure You Want to Use MMAP in Your Database Manage... by ori_b on Sunday July 02, 2023 @10:24PM (#36567973)
Hm. That seems to be comparing against leveldb, which at the time also used mmap. (It's since switched the default for performance reasons)
[ Parent | on HN ]