From owner-freebsd-stable@freebsd.org Wed Jul 1 10:20:33 2020 Return-Path: Delivered-To: freebsd-stable@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 44C4D34A9D7 for ; Wed, 1 Jul 2020 10:20:33 +0000 (UTC) (envelope-from lwhsu.freebsd@gmail.com) Received: from mail-yb1-f172.google.com (mail-yb1-f172.google.com [209.85.219.172]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1O1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 49xcgN3GX3z4G2M for ; Wed, 1 Jul 2020 10:20:32 +0000 (UTC) (envelope-from lwhsu.freebsd@gmail.com) Received: by mail-yb1-f172.google.com with SMTP id y13so11694322ybj.10 for ; Wed, 01 Jul 2020 03:20:32 -0700 (PDT) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=vRf94bD/5ABwZPva4k3g0XgjBQ7liK3RXab7bC2ABqc=; b=maxrUegZtMEunx5EL4t9AVUevPqHrsioeJmsxlLnsYb/5piNvn+plc0w5AOUIRWohn xkmqmhFopfgp5OjJijYzPhluDloRBrzmTZazbOZ6IuAY2cTo67Kv5RFJ84Xq75SgfJTO iLFz2GwmKU/wSksQMZYSm7pycoR2pbIs1ec4j8LvObJCATBb5Kwz58sDcqMnh+Xppj8h MIpgoIwv8wPPKG0C+DQ+O12sLapBb2LN5zIdO34JgjgzuDbWy6YBnw6lq6Gj1XfJ5qqD 17VheeY/IV25eMhDvDUs0SoQIzMIABe/eiRk2TJPFuPUHJSU2MNteJwuPecL+m6cP5tV QYOQ== X-Gm-Message-State: AOAM532qKHiKGhLQc0letc7if8FCuAR/LXyrt0lbSWB2A7ibdzeXk5ar 65SQd3pnOfpb5OLF3NXL6HLnZ47I7xdzRzuP1zW/yJw2 X-Google-Smtp-Source: ABdhPJwPhb0+GEzyiaWyb0q8n7fgKwmkRAEdZM4fS3if1rFgNLkNsldpVl7o+Lh7H7nZaHjipI6ir5o3JNMuI4I/DQk= X-Received: by 2002:a25:d088:: with SMTP id h130mr42446326ybg.451.1593598831302; Wed, 01 Jul 2020 03:20:31 -0700 (PDT) MIME-Version: 1.0 References: <20200701130649.0b0643d5@i11.co> In-Reply-To: <20200701130649.0b0643d5@i11.co> From: Li-Wen Hsu Date: Wed, 1 Jul 2020 18:20:19 +0800 Message-ID: Subject: Re: BerkeleyDB Hash vs Btree on FreeBSD and Linux To: Nick Kostirya Cc: freebsd-stable@freebsd.org Content-Type: text/plain; charset="UTF-8" X-Rspamd-Queue-Id: 49xcgN3GX3z4G2M X-Spamd-Bar: -- Authentication-Results: mx1.freebsd.org; dkim=none; dmarc=none; spf=pass (mx1.freebsd.org: domain of lwhsufreebsd@gmail.com designates 209.85.219.172 as permitted sender) smtp.mailfrom=lwhsufreebsd@gmail.com X-Spamd-Result: default: False [-2.42 / 15.00]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-0.91)[-0.914]; FROM_NEQ_ENVFROM(0.00)[lwhsu@freebsd.org,lwhsufreebsd@gmail.com]; FROM_HAS_DN(0.00)[]; TO_DN_SOME(0.00)[]; R_SPF_ALLOW(-0.20)[+ip4:209.85.128.0/17:c]; RCVD_TLS_ALL(0.00)[]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-stable@freebsd.org]; DMARC_NA(0.00)[freebsd.org]; NEURAL_HAM_LONG(-0.97)[-0.970]; TO_MATCH_ENVRCPT_SOME(0.00)[]; NEURAL_HAM_SHORT(-0.53)[-0.533]; RCPT_COUNT_TWO(0.00)[2]; RCVD_IN_DNSWL_NONE(0.00)[209.85.219.172:from]; FORGED_SENDER(0.30)[lwhsu@freebsd.org,lwhsufreebsd@gmail.com]; RWL_MAILSPIKE_POSSIBLE(0.00)[209.85.219.172:from]; R_DKIM_NA(0.00)[]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:209.85.128.0/17, country:US]; MIME_TRACE(0.00)[0:+]; TAGGED_FROM(0.00)[]; RCVD_COUNT_TWO(0.00)[2] X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.33 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 01 Jul 2020 10:20:33 -0000 On Wed, Jul 1, 2020 at 6:07 PM Nick Kostirya via freebsd-stable wrote: > > Hello. > > I noticed that BerkeleyDB Hash is VERY slow compared to BerkeleyDB Btree on FreeBSD (UFS or ZFS). > But they (Hash and Btree) have roughly the same performance on Linux. > > Why? It's not an easy question, do you have more information about the test environment setup, and the statistics of the results? I'd recommend using some analysis tools like DTrace to check what it's busy for. Li-Wen