From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id COo/FIhcqGDxAwAAgWs5BA (envelope-from ) for ; Sat, 22 May 2021 03:21:12 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id GMj7D4hcqGCpBwAA1q6Kng (envelope-from ) for ; Sat, 22 May 2021 01:21:12 +0000 Received: from mail.notmuchmail.org (nmbug.tethera.net [IPv6:2607:5300:201:3100::1657]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 0604F1CD5B for ; Sat, 22 May 2021 03:21:12 +0200 (CEST) Received: from nmbug.tethera.net (localhost [127.0.0.1]) by mail.notmuchmail.org (Postfix) with ESMTP id D7C8329039; Fri, 21 May 2021 21:20:55 -0400 (EDT) Received: from fethera.tethera.net (fethera.tethera.net [198.245.60.197]) by mail.notmuchmail.org (Postfix) with ESMTP id 5BF34271EC for ; Fri, 21 May 2021 21:20:52 -0400 (EDT) Received: by fethera.tethera.net (Postfix, from userid 1001) id 02A255FD25; Fri, 21 May 2021 21:20:49 -0400 (EDT) Received: (nullmailer pid 1412723 invoked by uid 1000); Sat, 22 May 2021 01:20:48 -0000 From: David Bremner To: notmuch@notmuchmail.org Subject: Commit after some number of transactions Date: Fri, 21 May 2021 22:20:35 -0300 Message-Id: <20210522012040.1412467-1-david@tethera.net> X-Mailer: git-send-email 2.30.2 MIME-Version: 1.0 Message-ID-Hash: HAA6JFNWCGCZG4YZM7OJOEMUSFW7VIDC X-Message-ID-Hash: HAA6JFNWCGCZG4YZM7OJOEMUSFW7VIDC X-MailFrom: bremner@tethera.net X-Mailman-Rule-Misses: dmarc-mitigation; no-senders; approved; emergency; loop; banned-address; member-moderation; header-match-notmuch.notmuchmail.org-0; nonmember-moderation; administrivia; implicit-dest; max-recipients; max-size; news-moderation; no-subject; suspicious-header X-Mailman-Version: 3.2.1 Precedence: list List-Id: "Use and development of the notmuch mail system." List-Help: List-Post: List-Subscribe: List-Unsubscribe: Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Migadu-Flow: FLOW_IN ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1621646472; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding:list-id:list-help: list-unsubscribe:list-subscribe:list-post; bh=NlL487pZCUsD4lsV0DfuwevKomykbzekPyb69n+BRYM=; b=sJRG5iLwNXo0j5uLBhC/Z+m5e4j05is5DYc6JHfJdwcBcj9LOrqWTYtRc2zf7E8pHAHSLF zB2fJYygRuxUM2X5LTDxpvRGjaOAflhl0Ach7nbl4TxUVmXXAfsFN3yDP+E5H/IWYUO5uE dLCXOr/IdLdcvS/dL9DTQVaK5rrXwnjzths5JrCRoi5IZKRdWvDIBfN/Xg5CoVU2C//yuL 8k4ZLv5NmDWl78VkA0zs4quj2D/2cT69QmEGbXZcD5jtyHhEQd2Ckdr8isPaJQlqw5hHsa LYmZhdTpa5b11M+Iw3hvgxpUsiYcMwk8qfFZp78CILp6zkLzurfadTo31oEpBQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1621646472; a=rsa-sha256; cv=none; b=VNN/Abeb1l3z3x6haZNDCEXu2NQZXocVO0kVFeiRUJYu/LixKGhFOaalrp9vNGchUcfvgO 6Ryl95DuqGerKzzYafLD9aKHW06W5iHKfwEGFzhFQFhDIFHQYNzFfXJCViPi3gd4BvjhEJ WW/ACzV21/6Ls96GPMgBazicvCaL5mwsVcHWabo0tk8l/hdzTLpjMV9hKKBz9OlRcF3G8L 58ULMWOHqdPDLywsesf5dXl4t/owI18T1570CpXsMu1T2fFKqWd5s6gyQV+qcyO9GEH3zi Ay2z8sFrKQnocggvm6Oa8STdHp7698QJ9iFyivBjR+/bWtZlz/jL0ntwT/s7Vg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of notmuch-bounces@notmuchmail.org designates 2607:5300:201:3100::1657 as permitted sender) smtp.mailfrom=notmuch-bounces@notmuchmail.org X-Migadu-Spam-Score: -1.07 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of notmuch-bounces@notmuchmail.org designates 2607:5300:201:3100::1657 as permitted sender) smtp.mailfrom=notmuch-bounces@notmuchmail.org X-Migadu-Queue-Id: 0604F1CD5B X-Spam-Score: -1.07 X-Migadu-Scanner: scn0.migadu.com X-TUID: Kc+JXzA+Senc The main rational is explained in the commit message to [PATCH 4/5] lib: autocommit after some number of completed I'm not super-happy with the documentation in [5/5], as it explains things in terms of database concepts the user shouldn't really need to understand. [PATCH 5/5] doc: document database.autocommit variable The default value of 8000 was chose not to cause any noticable slowdown when indexing the "large" corpus of about 200k messages. The test machine is a recent Xeon with fast spinning rust drives; the whole index takes about 8.5 minutes on this machine. I'd be curious if other people notice a performance impact. On the same machine the threshold of 8000 means that less than 30 seconds worth of work would be discarded.