Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZZhM-005x4A-1h for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Aug 2023 16:30:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qZZhK-004FBQ-32 for pgsql-hackers@arkaria.postgresql.org; Fri, 25 Aug 2023 16:30:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qZZhJ-004FBG-N9 for pgsql-hackers@lists.postgresql.org; Fri, 25 Aug 2023 16:30:09 +0000 Received: from mail-oi1-x232.google.com ([2607:f8b0:4864:20::232]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qZZhF-0010Xg-NP for pgsql-hackers@postgresql.org; Fri, 25 Aug 2023 16:30:08 +0000 Received: by mail-oi1-x232.google.com with SMTP id 5614622812f47-3a850f07fadso796647b6e.2 for ; Fri, 25 Aug 2023 09:30:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1692981003; x=1693585803; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=gxOtR4K9ZmsybwE7cgGrzEk0sanWge+0t6jQyeWqIIA=; b=a61dst549KvrpfIo4pbYtA92Lhom4w7bBr++dfhwXIRtIAzs2aZQpYKYQNx2vFLt3p AhkJKC/ltIVB9rA0VcOVD0phzg7kAUPRwJn9JPgmmuOh2FYCUNrPWV/Z1VrGc0WA+JRH twHnKgZv3c6ZLUowS5dGBaT63T8xrNQVgXcPAWhvT6hNOzVCZzU+ZwOoGCofSQ1WMaq+ u74cWQ8c+gz2mQwZ4ytpzxfC7opzcYUED4LrlS/Dg/TM2EHLm6t98S09YuAquiABuh36 HbXuPI78edU/NjnTae02hxEGSgRReM0u1zeKvolmrpY3q90uujPufyYsp6nOHMxDTX6n 6cOQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1692981003; x=1693585803; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=gxOtR4K9ZmsybwE7cgGrzEk0sanWge+0t6jQyeWqIIA=; b=D6HqPQSPM4PI3uHKKFfH+E7zteVeQTrekvejth9kOsOP/yK0Z0B794Ev0RxRxorsLP z33Xbo/fsgDUsPm1rSKD3kJwFS+imr7PLGo3Y0/+P3gRNtHEKhWcSsb3pGL3yIyOH6X0 QK0z+TdwLjByzDn8tPBskmHvdKDARyDwEFbdpfuDBRIuM0UTcMam+pr1LDAL+lAVLDnK pJ8MYuspPotc3JPd+gujNU6utieQahQLXVfFyb9BVx77/v9wphunRifXbTZnjqe2G2a+ oySHdA/PV5IFVzYLhqEEl0RvmTPuziPufm1suobVOu276puLEyreh95hPZkjClp5Akua eO5g== X-Gm-Message-State: AOJu0YzDd68Sk0XMP4GPGHhmV8Eb+ZGJgXLPmNGfYBbaTRuw8aEgqU/c +6rxqT41IPYrlKboxktTt8Yrf2u/ORc= X-Google-Smtp-Source: AGHT+IFRMo0YOK8m1QKz8nM2E+de+Svl/b735XEsExeD2+Oqb8gbD33k8L1w4WXDiow4lmSVWbUihw== X-Received: by 2002:a05:6808:48e:b0:3a8:7c67:7cd with SMTP id z14-20020a056808048e00b003a87c6707cdmr3055469oid.24.1692981003635; Fri, 25 Aug 2023 09:30:03 -0700 (PDT) Received: from nathanxps13 ([2600:1700:48f8:340f:3c05:5c50:8af3:3697]) by smtp.gmail.com with ESMTPSA id t8-20020a0568080b2800b003a7527207b5sm910413oij.7.2023.08.25.09.30.02 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 25 Aug 2023 09:30:02 -0700 (PDT) Date: Fri, 25 Aug 2023 09:29:59 -0700 From: Nathan Bossart To: Andres Freund Cc: Daniel Gustafsson , Tom Lane , Thomas Munro , Robert Haas , PostgreSQL Hackers Subject: Re: initdb caching during tests Message-ID: <20230825162959.GA1868023@nathanxps13> References: <540868.1642611241@sss.pgh.pa.us> <20220119170330.e4gnubxpkbw2lhpl@alap3.anarazel.de> <542839.1642612461@sss.pgh.pa.us> <20220119174231.3gj4lnsilvguhyp3@alap3.anarazel.de> <20220120021859.3zpsfqn4z7ob7afz@alap3.anarazel.de> <20230805195656.wouaaf6qvrdo2cjt@awork3.anarazel.de> <20230823011745.jjj3fvo6njubifn4@awork3.anarazel.de> <20230824221000.y5owt6c2bddyuy6o@alap3.anarazel.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20230824221000.y5owt6c2bddyuy6o@alap3.anarazel.de> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, Aug 24, 2023 at 03:10:00PM -0700, Andres Freund wrote: > Cool. Pushed that way. I just noticed the tests running about 30% faster on my machine due to this. Thanks! -- Nathan Bossart Amazon Web Services: https://aws.amazon.com