From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:bcc0::]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) by ms0.migadu.com with LMTPS id YDFKH6RQdmBbjwAAgWs5BA (envelope-from ) for ; Wed, 14 Apr 2021 04:17:08 +0200 Received: from aspmx1.migadu.com ([2001:41d0:2:bcc0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id 8O4MGaRQdmBNCgAAbx9fmQ (envelope-from ) for ; Wed, 14 Apr 2021 02:17:08 +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 2802F1EAA3 for ; Wed, 14 Apr 2021 04:17:08 +0200 (CEST) Received: from nmbug.tethera.net (localhost [127.0.0.1]) by mail.notmuchmail.org (Postfix) with ESMTP id 7E5E326876; Tue, 13 Apr 2021 22:16:41 -0400 (EDT) Received: from fethera.tethera.net (fethera.tethera.net [198.245.60.197]) by mail.notmuchmail.org (Postfix) with ESMTP id A497A1FBCE for ; Tue, 13 Apr 2021 22:16:34 -0400 (EDT) Received: by fethera.tethera.net (Postfix, from userid 1001) id 5D5755FA96; Tue, 13 Apr 2021 22:16:32 -0400 (EDT) Received: (nullmailer pid 1236634 invoked by uid 1000); Wed, 14 Apr 2021 02:16:30 -0000 From: David Bremner To: notmuch@notmuchmail.org Subject: Deletion speed improvements for notmuch-new Date: Tue, 13 Apr 2021 23:16:25 -0300 Message-Id: <20210414021627.1236560-1-david@tethera.net> X-Mailer: git-send-email 2.30.2 MIME-Version: 1.0 Message-ID-Hash: N6EEAW4WB72VEZAZFS74FKF5VTRXANET X-Message-ID-Hash: N6EEAW4WB72VEZAZFS74FKF5VTRXANET 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=1618366628; 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=boqqxkebWYos/vhex+B0pI1DHHXXW65Ic0YZ5Zg86Qo=; b=JXtsOV5BIkglSgrXlnNDwfTYsvy8/IJa/smOeLfXqm0n20y3cW4Ag00oUifumuY/DO22Tc jrXl5sR28Bw7/8NSr2l7Vq2w9lC9SQhVSTu3Vh3VBg7ytN331mRQUOnnITyAJbiZaY6HZU UVUlLheFqYspb62TC0gpItBXMf25tBWVP+3gWrXFjCCYELf9uppi7MsJtcMYcLCImxFXEb z+ilXcXl0I88TEFgmLEOlC5DU5N3G2BLDtDR4oVnwbG5zffQ9KAGZj6GdTjy+KZ9hLhWvJ iOA8HXr369blwTbwFJD3fPxBgj0jSaX+WbnvnHPg+AMi8bClSThP0o7Fnk4tBQ== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1618366628; a=rsa-sha256; cv=none; b=A2T3CsRpshlFtQTAn32zrG6r55Pt+Lw2NxzTKaXemvYRNDcu+LHmuk0WaQ4HFcjILY19n6 Bgsdi5rxLgfd26S0LcDTiXcxMe80Sp9XsEW3xiz/3pbW6Hs43LDYkt1p51/vyiNLLOrlXO jNOHZn8yW7pYiiek4smCikgo+FbXnlOehMQ1AcaLKoruOLHbNW4oUkztGgTpVMwJQmkK2e /zwmKdwVxNYXfLfSrsOHMR6PSth6sXiaz8K8Q2nWS9otvqULJuYiGXU1BzxFTXC2aErenW w645sqEfo7VuelOKOjm1AxLlGYhvbsFO4oxkFpu2gZromx/6RrNEKeI9N1Y7XA== 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: 0.99 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: 2802F1EAA3 X-Spam-Score: 0.99 X-Migadu-Scanner: scn0.migadu.com X-TUID: SyRwFUoY1kha These are a bit rough around the edges, but I wanted to see if we could get them into shape for the 0.32 release, since the performance improvement for me is pretty drastic. I would appreciate testing, since I think the performance test may be kindof best case in avoiding long threads. [PATCH 1/2] WIP: add performance test for removing files. -- this needs someone (Tomi?) to fix my gnu centric tar usage [PATCH 2/2] WIP: replace use of queries in n_m_delete with postlist this leads to (at least) a 30x improvement in the test introduced above with the medium corpus; I ran out of patience waiting for the unpatched version.