From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on dcvr.yhbt.net X-Spam-Level: X-Spam-Status: No, score=-3.2 required=3.0 tests=AWL,BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,RCVD_IN_DNSWL_NONE, SPF_HELO_NONE,SPF_PASS shortcircuit=no autolearn=ham autolearn_force=no version=3.4.2 Received: from mail-qk1-x72c.google.com (mail-qk1-x72c.google.com [IPv6:2607:f8b0:4864:20::72c]) (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) (No client certificate requested) by dcvr.yhbt.net (Postfix) with ESMTPS id 480591F55B for ; Wed, 27 May 2020 20:03:01 +0000 (UTC) Received: by mail-qk1-x72c.google.com with SMTP id s1so807939qkf.9 for ; Wed, 27 May 2020 13:03:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=linuxfoundation.org; s=google; h=date:from:to:cc:subject:message-id:mail-followup-to:references :mime-version:content-disposition:in-reply-to; bh=rbW+s4twkt76bJcoRHj6s2CU69jwEkP2y4xNkSfc3aQ=; b=F1LueV0T4NqVukfY//j7FA7yjuDWTx89jfiXLqr/pAPJlHDh7Om2MQUMR0f0bsIqXh ++4L1v7WiqE7SXdRfZm2OQ9Dj4ZaZvnXDWu9rCWpDMUEdJ904cZgKjI0UG8bChOh3xJ2 ksccIBGLZfaysOITq5w7YE3YfUEXeIkrElDis= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id :mail-followup-to:references:mime-version:content-disposition :in-reply-to; bh=rbW+s4twkt76bJcoRHj6s2CU69jwEkP2y4xNkSfc3aQ=; b=chyg2t02eyXcvrDTxViCrYQDjMu+aoV6pmFvcFyP1QLdf5tzwILV++wmVoiqHkQP86 /dkanJLMXjmC97mB1muqQpSOdZY2kcbTsf8YxEjQ6shzw4QMbWh/cfFGZRmPc8++OR56 ErMfJtk0xO7EI+2zb34Uwy2W4XvrBeeMyOI//DBr3U80QH/zgAn5UGrrzmBNRuVtMPEG xc15XOyCnfksnOZuePyoAnhwTzsIEFD6W+33rPNzDP3XiqtxR61zjj4fsssr5rQ8Ur5w AJcY8ENqMwLZwg1a882liqXYeKniodVcf+5RixML4phOHcLJXiNd6gLgRDd7wYn85vVb Emgg== X-Gm-Message-State: AOAM530ja7M7tExHW8d1Ght8Nxy38+YTK4DL7qmzhkxx21y4cbqOrK6h rJJqTHkH/+yd7syaEPwNKJCV/LhA1lY= X-Google-Smtp-Source: ABdhPJyAH8yMi0/DMlSD6YPQ45NULYafPnkAV+LubGmsOFUSB2fBpJkfSRZS58F34GOA2okCLxj2oQ== X-Received: by 2002:a37:b107:: with SMTP id a7mr5527732qkf.133.1590609780050; Wed, 27 May 2020 13:03:00 -0700 (PDT) Received: from chatter.i7.local ([87.101.92.156]) by smtp.gmail.com with ESMTPSA id k12sm619350qkk.58.2020.05.27.13.02.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 27 May 2020 13:02:59 -0700 (PDT) Date: Wed, 27 May 2020 16:02:57 -0400 From: Konstantin Ryabitsev To: Eric Wong Cc: meta@public-inbox.org Subject: Re: Search based on data in follow-ups Message-ID: <20200527200257.GB25485@chatter.i7.local> Mail-Followup-To: Eric Wong , meta@public-inbox.org References: <20200526191745.34vynfasnf3amyjq@chatter.i7.local> <20200526213550.GA20081@dcvr> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <20200526213550.GA20081@dcvr> List-Id: On Tue, May 26, 2020 at 09:35:50PM +0000, Eric Wong wrote: > > - (subject contains "PATCH") AND (follow-up from testbot@example.com > > that contains "Passed") AND NOT (follow-up from me that contains > > "Applied|NACK") > > > > I expect this would require client-side filtering, though, as I can't > > imagine being able to sanely do this with Xapian. > > Without promising anything, it could be doable server-side if > we're careful to not hog the event loop. It'll depend on the > "mairix -t" functionality I've talked about, and maybe multiple > queries to Xapian or SQLite... > > It would take extra CPU for sure, what's CPU usage look like on > lore at peak times? That system also houses lore.kernel.org/patchwork, and that tends to significantly skew the load graph. At any rate, lore is not loaded at all -- usually around 0.3. -K