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 OkBKEY7Upl71awAA0tVLHw (envelope-from ) for ; Mon, 27 Apr 2020 12:48:14 +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 GHHiIJbUpl4GJwAAbx9fmQ (envelope-from ) for ; Mon, 27 Apr 2020 12:48:22 +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 DF7229422D0 for ; Mon, 27 Apr 2020 12:48:20 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by arlo.cworth.org (Postfix) with ESMTP id 7E0FB6DE0ACD; Mon, 27 Apr 2020 05:48:17 -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 4j7jVVDp9sjO; Mon, 27 Apr 2020 05:48:17 -0700 (PDT) Received: from arlo.cworth.org (localhost [IPv6:::1]) by arlo.cworth.org (Postfix) with ESMTP id 566386DE0EDC; Mon, 27 Apr 2020 05:48:16 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by arlo.cworth.org (Postfix) with ESMTP id 3E7836DE0EDC for ; Mon, 27 Apr 2020 05:48:15 -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 yYAToh4z2S7w for ; Mon, 27 Apr 2020 05:48:10 -0700 (PDT) Received: from us-smtp-1.mimecast.com (us-smtp-delivery-1.mimecast.com [207.211.31.120]) by arlo.cworth.org (Postfix) with ESMTPS id ABB086DE0ACD for ; Mon, 27 Apr 2020 05:48:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=redhat.com; s=mimecast20190719; t=1587991688; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=YXj3jgeu03wF9Kuo357lf3Fiyk8Fvex7l6jpp+FtaQQ=; b=FmAbYeEYYbSGvxjHdsKWR39kluRIRhvBF2SkYbIZSWPPkM5XNHrvsXrrvx1xYefF0e7mMj Fqd1eO48eMzUYy4CWbtJ+PjtLoC9hjNjgMI79u7w6nwwGCRY3SGPWnsWna8k2yfn/TVqzz bh2plnE0IS3laq0gARBG0WUB8KnTmpA= Received: from mimecast-mx01.redhat.com (mimecast-mx01.redhat.com [209.132.183.4]) (Using TLS) by relay.mimecast.com with ESMTP id us-mta-375-1FcMoFGZOIyQrR2YPcr_lg-1; Mon, 27 Apr 2020 08:48:05 -0400 X-MC-Unique: 1FcMoFGZOIyQrR2YPcr_lg-1 Received: from smtp.corp.redhat.com (int-mx07.intmail.prod.int.phx2.redhat.com [10.5.11.22]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by mimecast-mx01.redhat.com (Postfix) with ESMTPS id 8ABF41009440; Mon, 27 Apr 2020 12:48:03 +0000 (UTC) Received: from redhat.com (ovpn-116-138.rdu2.redhat.com [10.10.116.138]) by smtp.corp.redhat.com (Postfix) with ESMTPS id 540A41000329; Mon, 27 Apr 2020 12:48:02 +0000 (UTC) Date: Mon, 27 Apr 2020 08:48:00 -0400 From: Don Zickus To: David Bremner Subject: Re: performance problems with notmuch new Message-ID: <20200427124800.6xkutxg2vrsecvql@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> <87mu70jxe8.fsf@tethera.net> MIME-Version: 1.0 In-Reply-To: <87mu70jxe8.fsf@tethera.net> X-Scanned-By: MIMEDefang 2.84 on 10.5.11.22 X-Mimecast-Spam-Score: 0 X-Mimecast-Originator: redhat.com Content-Disposition: inline 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: 0.09 Authentication-Results: aspmx1.migadu.com; dkim=fail (body hash did not verify) header.d=redhat.com header.s=mimecast20190719 header.b=FmAbYeEY; dmarc=fail reason="SPF not aligned (relaxed)" header.from=redhat.com (policy=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 [0.09 / 13.00]; GENERIC_REPUTATION(0.00)[-0.46230127325371]; 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)]; DWL_DNSWL_FAIL(0.00)[50.126.95.6:server fail]; R_DKIM_REJECT(1.00)[redhat.com:s=mimecast20190719]; MX_GOOD(-0.50)[cached: notmuchmail.org]; RCPT_COUNT_TWO(0.00)[2]; DKIM_TRACE(0.00)[redhat.com:-]; MAILLIST(-0.20)[mailman]; MIME_TRACE(0.00)[0:+]; RCVD_TLS_LAST(0.00)[]; ASN(0.00)[asn:27017, ipnet:50.126.64.0/18, country:US]; MID_RHS_MATCH_FROM(0.00)[]; FROM_NEQ_ENVFROM(0.00)[dzickus@redhat.com,notmuch-bounces@notmuchmail.org]; ARC_NA(0.00)[]; URIBL_BLOCKED(0.00)[notmuchmail.org:email]; FROM_HAS_DN(0.00)[]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[notmuch@notmuchmail.org]; HAS_LIST_UNSUB(-0.01)[]; DNSWL_BLOCKED(0.00)[50.126.95.6:from]; RCVD_COUNT_SEVEN(0.00)[10]; FORGED_SENDER_MAILLIST(0.00)[]; DMARC_POLICY_SOFTFAIL(0.10)[redhat.com : SPF not aligned (relaxed),none] X-TUID: P4tf7p5iAe+l On Fri, Apr 24, 2020 at 08:07:27PM -0300, David Bremner wrote: > 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. Does that mean 'notmuch dump' and 'notmuch restore'? Willing to try that. Cheers, Don