From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id hFdaLDVxo16tHgAA0tVLHw (envelope-from ) for ; Fri, 24 Apr 2020 23:07:33 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id MICQAD1xo14gYQAAbx9fmQ (envelope-from ) for ; Fri, 24 Apr 2020 23:07:41 +0000 Received: from arlo.cworth.org (arlo.cworth.org [50.126.95.6]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) server-signature RSA-PSS (4096 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 83EEC943230 for ; Fri, 24 Apr 2020 23:07:39 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by arlo.cworth.org (Postfix) with ESMTP id E5B0F6DE13ED; Fri, 24 Apr 2020 16:07:34 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at cworth.org Received: from arlo.cworth.org ([127.0.0.1]) by localhost (arlo.cworth.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id jzqd8ynjYf7v; Fri, 24 Apr 2020 16:07:33 -0700 (PDT) Received: from arlo.cworth.org (localhost [IPv6:::1]) by arlo.cworth.org (Postfix) with ESMTP id 647976DE13DA; Fri, 24 Apr 2020 16:07:33 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by arlo.cworth.org (Postfix) with ESMTP id C50F66DE13DA for ; Fri, 24 Apr 2020 16:07:32 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at cworth.org Received: from arlo.cworth.org ([127.0.0.1]) by localhost (arlo.cworth.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id FROHz0absplg for ; Fri, 24 Apr 2020 16:07:31 -0700 (PDT) Received: from fethera.tethera.net (fethera.tethera.net [198.245.60.197]) by arlo.cworth.org (Postfix) with ESMTPS id DF6406DE13D5 for ; Fri, 24 Apr 2020 16:07:31 -0700 (PDT) Received: from remotemail by fethera.tethera.net with local (Exim 4.92) (envelope-from ) id 1jS7Pt-0004I0-62; Fri, 24 Apr 2020 19:07:29 -0400 Received: (nullmailer pid 3072638 invoked by uid 1000); Fri, 24 Apr 2020 23:07:27 -0000 From: David Bremner To: Don Zickus Subject: Re: performance problems with notmuch new In-Reply-To: <20200424190526.gfypvd4aooe34y6t@redhat.com> References: <20200415150801.h2mazyo37sspvech@redhat.com> <874ktku49b.fsf@tethera.net> <20200415173138.rn3ubtxo6mkracss@redhat.com> <87y2qwsdba.fsf@tethera.net> <20200420152519.gt73upo6mowhzsca@redhat.com> <87y2qljhlk.fsf@tethera.net> <20200424190526.gfypvd4aooe34y6t@redhat.com> Date: Fri, 24 Apr 2020 20:07:27 -0300 Message-ID: <87mu70jxe8.fsf@tethera.net> MIME-Version: 1.0 X-BeenThere: notmuch@notmuchmail.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Use and development of the notmuch mail system." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: notmuch@notmuchmail.org Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Errors-To: notmuch-bounces@notmuchmail.org Sender: "notmuch" X-Scanner: scn0 X-Spam-Score: -1.01 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; spf=pass (aspmx1.migadu.com: domain of notmuch-bounces@notmuchmail.org designates 50.126.95.6 as permitted sender) smtp.mailfrom=notmuch-bounces@notmuchmail.org X-Scan-Result: default: False [-1.01 / 13.00]; ARC_NA(0.00)[]; GENERIC_REPUTATION(0.00)[-0.46241826795079]; MID_RHS_MATCH_FROM(0.00)[]; FROM_HAS_DN(0.00)[]; TO_DN_SOME(0.00)[]; R_SPF_ALLOW(-0.20)[+a:c]; IP_REPUTATION_HAM(0.00)[asn: 27017(-0.18), country: US(-0.00), ip: 50.126.95.6(-0.46)]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[notmuch@notmuchmail.org]; DMARC_NA(0.00)[tethera.net]; HAS_LIST_UNSUB(-0.01)[]; DNSWL_BLOCKED(0.00)[50.126.95.6:from]; URIBL_BLOCKED(0.00)[notmuchmail.org:email]; RCVD_TLS_LAST(0.00)[]; MX_GOOD(-0.50)[cached: notmuchmail.org]; RCPT_COUNT_TWO(0.00)[2]; DWL_DNSWL_FAIL(0.00)[50.126.95.6:server fail]; MAILLIST(-0.20)[mailman]; FORGED_SENDER_MAILLIST(0.00)[]; R_DKIM_NA(0.00)[]; MIME_TRACE(0.00)[0:+]; ASN(0.00)[asn:27017, ipnet:50.126.64.0/18, country:US]; FROM_NEQ_ENVFROM(0.00)[david@tethera.net,notmuch-bounces@notmuchmail.org]; RCVD_COUNT_SEVEN(0.00)[8] X-TUID: 22P/UgRvuUav Don Zickus writes: > > Of course I am using this in a strange context. I am deleting emails > locally and then running 'notmuch new' to clean up the database. > [snip] > So maybe my use case is unusual and the slowness is expected. I'd say it's a known performance bug in notmuch that it doesn't deal well with large numbers of deletions. At some point it is faster to reindex the whole database from scratch. d