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 1uaFBV-002Iug-6q for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Jul 2025 14:57:09 +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 1uaFBT-005VZN-8N for pgsql-hackers@arkaria.postgresql.org; Fri, 11 Jul 2025 14:57:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uaFBS-005VZE-UR for pgsql-hackers@lists.postgresql.org; Fri, 11 Jul 2025 14:57:07 +0000 Received: from mail-il1-x12e.google.com ([2607:f8b0:4864:20::12e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uaFBR-006mHk-25 for pgsql-hackers@lists.postgresql.org; Fri, 11 Jul 2025 14:57:06 +0000 Received: by mail-il1-x12e.google.com with SMTP id e9e14a558f8ab-3df4bdadca5so8211945ab.1 for ; Fri, 11 Jul 2025 07:57:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1752245825; x=1752850625; darn=lists.postgresql.org; 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=ZKkdE1lmn0s7A6WQh0CQx5ty38ey3YFt+19hgfgYo8s=; b=Ub6dbC17ORcWE110UpFgi+IkUlj3MSKWhGTptetPZGgRf3EEfOYBkLNcpf+xxe6GwL f2TPa2u5QwmZWHBaVCEiaU1V4gMJuMJIEGgzpC6thPTqBIdK7Q/uaIR+CyLI4o6bekwf BJL8mMJqUg2YHxD0id51yt4RdROhKtMa/UB4AFaCxJe1ygQNZultwNmSYMwHWl8UAXNc yJttBuA3kCLm3ZN9jgJCshvKivp48SVcKzQcUsWE7ar3MbJWuyoQQNDQrjaBJkrBzUfX XN9ZW0N85TIVaF6GfXDtWSQVGF7CUC1xDQaON1IgTMp2GKKI9qzEM4aNMkz6Q/3LNsAR 58ZA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1752245825; x=1752850625; 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=ZKkdE1lmn0s7A6WQh0CQx5ty38ey3YFt+19hgfgYo8s=; b=qTwKBkLJQObFJWFhV5kl22A0SzbObVltYnYKFx6m4Knh9qY6kcKH/aZ8ZN8IvQhbRq Ft/DzZSP9HRv6FDJt9yvORUrAtQGIwzyurZzucezPjg5KAV73abZj0Q0o+RIuEgQ1JZs 2weSyBhKfKyRSenZUEDRayg0DN7rAyFxY9gqny+IE+HfRCRB/6gKvKdTuXpCY81/FzHl e8rC8aJOXuG8yXefrO/b0qaCoTMkVGwbz0o0KFJ490QJ5mNRbb0L6YzP0J9W2k/hY3HP kR+PqeJLronOvf113+FWwWagyIuFnFHbVSNN0tOJj4mnPayiTrgmxa5j/X0bCWcLQ7kA lsVQ== X-Forwarded-Encrypted: i=1; AJvYcCXJgofHrW6wlwXvaGfj17FNRDJB5YK5yOEEZ+4E7CIlsCfF39D0WmL3Gf05j4YqnB8M4hOtBFdG1Hr7U67m@lists.postgresql.org X-Gm-Message-State: AOJu0YzigiKjJdNl726mOIapGhDn63ytqeVpT2o5pleNUrBHD9nWClRa 7pvqHVzL/u/nA8dZ0VsgC/d4v/I9Uj6CuzMByd8u1nmjG0/Jux7wcb7F X-Gm-Gg: ASbGncvoBSHryRDATyZMRQPRhDXNO+lspXtdAzXiNwzl3ypiTdNH23ARCUPRG8Ctmym +1IcJjuaVNCF79N9cyAlI709d2dtImS5yHg5S+ulaAlQeK+/h8yqeeCOM2cPa3imyEFdcWbpQnZ 2Rbkms97R8YdDzY7DuSmiwBFVPDH1Xyri1HB28GYGlIvnmki3rP7tmB9WxPag2vrjTUWltWJnQ2 UyxjDrKLDE9c2JIM/k0humvnP9izCWvMne5pyDfN1bsHjkelHeaNv9muVCn6DvC50FXom7tiQfB JFg3mpthbhg9RU0euPP8sdJVfunONifNzInSqHcQp3pXE4uT9YRAU/HGB0+fvgc9IwQVs/c7+OO VzH+j5KuG+7QW95Dmjouz2UxhxtQO5vC9Q0d5LkrV+mXoDzaXn+zqQfmr2r7WD2Wy8z/mGW5G6L ZVxylx4EhvNA7wV2T5uHI8MR4= X-Google-Smtp-Source: AGHT+IHVkuLwZ+4Qvue4SDSkXsHUiKvBwVzHqBAC9Opk9GLT2fq9An7ORKQIWNOJ35QM9v88pp1+BA== X-Received: by 2002:a05:6e02:198b:b0:3dd:d33a:741a with SMTP id e9e14a558f8ab-3e253325ffbmr41299115ab.18.1752245824911; Fri, 11 Jul 2025 07:57:04 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id 8926c6da1cb9f-50556970e1esm888483173.75.2025.07.11.07.57.04 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 11 Jul 2025 07:57:04 -0700 (PDT) Date: Fri, 11 Jul 2025 09:57:02 -0500 From: Nathan Bossart To: Dilip Kumar Cc: Fujii Masao , Christoph Berg , Laurenz Albe , Andres Freund , PostgreSQL Hackers Subject: Re: CHECKPOINT unlogged data Message-ID: References: <6c4a6fe7-a530-4f21-aa38-9e3adbcc5410@oss.nttdata.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Jul 11, 2025 at 08:43:05AM +0530, Dilip Kumar wrote: > Thanks now, looks good to me. Thanks for reviewing. > Additionally IMHO it would be good to add tests with FLUSH_UNLOGGED TRUE > and FLUSH_UNLOGGED FALSE as well, I have added a simple 2 test for the > same in attached file. I'll add something like this before committing. In the future, please do not post small add-on patches like this because it confuses cfbot. If you must, I think appending an unknown extension like ".nocfbot" to the file name is sufficient to prevent cfbot from picking it up. -- nathan