The jemalloc extension replaces the system's memory allocator with jemalloc. Unlike other DuckDB extensions, the jemalloc extension is statically linked and cannot be installed or loaded during runtime.
Operating System Support
The availability of the jemalloc extension depends on the operating system.
Linux
On Linux, the AMD64 (x86_64) distribution of DuckDB ships with the jemalloc extension. To disable the jemalloc extension, build DuckDB from source and set the SKIP_EXTENSIONS flag as follows:
GEN=ninja SKIP_EXTENSIONS="jemalloc" make The ARM64 (AArch64) DuckDB distribution on Linux does not ship with the jemalloc extension. To include it, build it as follows:
GEN=ninja BUILD_JEMALLOC=1 make macOS
The macOS version of DuckDB does not ship with the jemalloc extension but can be built from source to include it:
GEN=ninja BUILD_JEMALLOC=1 make Windows
On Windows, this extension is not available.
Configuration
Environment Variables
The jemalloc allocator in DuckDB can be configured via the MALLOC_CONF environment variable.
Background Threads
By default, jemalloc's background threads are disabled. To enable them, use the following configuration option:
SET allocator_background_threads = true; Background threads asynchronously purge outstanding allocations so that this doesn't have to be done synchronously by the foreground threads. This improves allocation performance, and should be noticeable in allocation-heavy workloads, especially on many-core CPUs.