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.4 required=3.0 tests=AWL,BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,DKIM_VALID_EF,RCVD_IN_DNSWL_BLOCKED, SPF_HELO_NONE,SPF_PASS shortcircuit=no autolearn=ham autolearn_force=no version=3.4.2 Received: from mail-qv1-xf31.google.com (mail-qv1-xf31.google.com [IPv6:2607:f8b0:4864:20::f31]) (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 53D1C1F4B4 for ; Tue, 8 Dec 2020 18:11:44 +0000 (UTC) Received: by mail-qv1-xf31.google.com with SMTP id l14so333994qvh.2 for ; Tue, 08 Dec 2020 10:11:44 -0800 (PST) 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=IwcPTu2U1wMr+DgrLIGXColkZTg1zgpTSexaEU45oIg=; b=bR2YHwVXoMbTng9ydgiLRHl/r0PrZdp8Ta3aja1ZJcRvXrbK8dfEFlKKRSy+fJ5kVq tmFZ6JaEVQ7nT2voaF9iRJ1wXZRqov2+j2GPZsaeSzDf+e4gyAXTBhhXmV3X4rcoibvZ X72Q/3rJPbYU40gMabR/2D03pA1lAWyoUC2/E= 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=IwcPTu2U1wMr+DgrLIGXColkZTg1zgpTSexaEU45oIg=; b=NaJBEKIet4/fGTJHMmpjWdZbWxDo9Bi9joB/o/lRt5ivRDe0afcw27bfx7YImJEK4s VStZxRK+oa1SNR2L81LxX5CCK0V1I1bHs0hJIh/mXQ6CJUaVoOGJysz6MXoJWIU6fmVF Pz0aD9lfKDdmPYxbfT4cmr9Qf3bAaohMktfA/Q6hhcndWm/az0MeRUzhcpdAZOP1/6K7 wvMplxKms700QiskP+x/Zit+jm+/9/SJd+3lA+cL1n06lN8fM24FV3vOifbRYuioS9k5 OqIRR4p7NI1jy1MbGxEHn1R/GIa6ny8UQno9mtg4+6RgbVdHd8HQydRFaEwV+Si5thV2 yLGQ== X-Gm-Message-State: AOAM530+NF6XXK61kBxbQsdYJTAwWq8atjdoDehvFmlvlurP4m4h5nwg 30BEgycPbJJEmdfd4aNnfZpKLA== X-Google-Smtp-Source: ABdhPJyYuWL5emtVTWHgnv731ibZBep0AUewnwRwqhtkuFAqtS9+p5302ODphDEZrtunZwEg3a2M1g== X-Received: by 2002:ad4:4761:: with SMTP id d1mr15212714qvx.12.1607451102982; Tue, 08 Dec 2020 10:11:42 -0800 (PST) Received: from chatter.i7.local ([89.36.78.230]) by smtp.gmail.com with ESMTPSA id u26sm2000489qke.57.2020.12.08.10.11.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Tue, 08 Dec 2020 10:11:42 -0800 (PST) Date: Tue, 8 Dec 2020 13:11:40 -0500 From: Konstantin Ryabitsev To: Eric Wong Cc: workflows@vger.kernel.org, meta@public-inbox.org Subject: Re: WIP: searching all of lore Message-ID: <20201208181140.2ysin3tgqithdmel@chatter.i7.local> Mail-Followup-To: Eric Wong , workflows@vger.kernel.org, meta@public-inbox.org References: <20201126194543.GA30337@dcvr> <20201128223457.GA31347@dcvr> <20201205200717.GA7923@dcvr> <20201208140111.3lxecf42d6ooskeb@chatter.i7.local> <20201208180232.GA20637@dcvr> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline In-Reply-To: <20201208180232.GA20637@dcvr> List-Id: On Tue, Dec 08, 2020 at 06:02:32PM +0000, Eric Wong wrote: > > So, are things to the point where we only need a single xapian db > > for all lists, or do we still need to keep individual list indexes? > > Only indexlevel=basic (sqlite) for individual lists. This saves > a bunch of FDs and provides ~60G overall space savings (not compacted). > > For all of lore: > > git + {over,msgmap}.sqlite3: 51G > extindex "all" over.sqlite3 + Xapian: 193G Sweet, now I'm getting excited all over again. :) -K