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 1vE8SO-0061Bs-27 for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Oct 2025 15:51:27 +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 1vE8SL-0020VU-Ir for pgsql-hackers@arkaria.postgresql.org; Wed, 29 Oct 2025 15:51:24 +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 1vE8SL-0020VM-00 for pgsql-hackers@lists.postgresql.org; Wed, 29 Oct 2025 15:51:24 +0000 Received: from mail-io1-xd2b.google.com ([2607:f8b0:4864:20::d2b]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vE8SH-004POg-2X for pgsql-hackers@postgresql.org; Wed, 29 Oct 2025 15:51:23 +0000 Received: by mail-io1-xd2b.google.com with SMTP id ca18e2360f4ac-93eab530884so1473839f.3 for ; Wed, 29 Oct 2025 08:51:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1761753081; x=1762357881; darn=postgresql.org; h=in-reply-to:content-transfer-encoding:content-disposition :mime-version:references:message-id:subject:cc:to:from:date:from:to :cc:subject:date:message-id:reply-to; bh=dYZDmbmQCvPAceQ/f8j5hhb2QoEw0EGojrQ8esW/xT4=; b=SaBDvYUNPZSGKNtQN6Xb/OvKgUPssuj00qpj6//coR4bPx4qaRObZDc0AfeWMNAtEo mu1KjiUJv/6uhC/79cK+tWFJp3jdqKOj9q10zk5KsNy/5TfXRMdwB2pcqqzMcj0QLxLL NFtQsyE05UziBebTbXXiGGE6rexE3kZpIQL+7Y7Utgj/CM45PEoItPxxFcU02s8BkibF HZVGR/Cb1nupnG3rMcP76Yb/M2FktTcXRx9YvXaIKglxIaUaEmUn6drrd906JHdzQ5Zx Rvcq73f2Eat/UwNcrDfUXmF4rcxg9Dc1hDGiWrJ0mZ/IJAfLUQv4GdybAJupDgtgo6lz 2NCw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1761753081; x=1762357881; h=in-reply-to:content-transfer-encoding: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=dYZDmbmQCvPAceQ/f8j5hhb2QoEw0EGojrQ8esW/xT4=; b=OrQH52maIu9xrUdyYkAPUQ2NIe3GNWnplSbxNKb2HsIajmIxRtLKUxAnptrDqhWoj5 PLSEqNsZZgRVu8ptm9wPnlY0zurFRhURXLxi1CJJfPpx+v4JkV5OjT+cs5kIaxXqbEAN 7Km9QwMiQwiIL2Uhp5qG3mPYLA5b42eq+ctOnb+KjawVmlM/G6sFDiClwYoXZNEuwgE7 m6pTaRkVwY9iQMpvKeN5Pu9C+olDkujvIpSNhoyYDFJT/Nj3R+IGyt60jqmbEf83F0Aw NbSKJDFhkSlBa+xwoBuyO0rXwHD489uB9ymBUW5zC1B7xdUPR0VcHeFLoEIp6wh8Q4Do JoZg== X-Forwarded-Encrypted: i=1; AJvYcCWYAjcKxhx9qc0m/29Qbw8HA+5IGE64xF/TYXgRwaltpQoO04I+YdiCLVIKu4/Z6kuyUFSw6U8oQmnkG5XS@postgresql.org X-Gm-Message-State: AOJu0YxzUmNFIhPrLMQdywOuHtrdEJw9ws7NRnhj9F//WpMjsmasGmos TWL8tAXn7KTJmSKFBsXZ1jw7NIdLtkFOcr/CE5BJ15YHWZBTX0QOnD8t X-Gm-Gg: ASbGncuPXd16i5rI7L5aPv5CfvrcIw16sIPPX2ugSmlLXkXZxR4UrOgOF0xT58zihKP sWHMMWW4ZoJO4vAlJrVpJifo9saiQ5t3kvqm6XYkwRYvJQm/uIz47OmSK8EtZKnMqQB3IGYSOW+ STi0meES+oG9S/LOw2AasWj2kLahK9AySUJqiKF2GFSFNLT3Rq3j0CCef2BMakiLsP6eLcFFbgV 6BMEpGxwwd3XIHFT9IM5S1qMpWxzVerAH9fF0YIKt2ffCVk87Bi7FGkioNN8qVk3LusP6bNCj5w Dyhn0M1m6NH/k6x3z5HiqN7Yka4scsLhovqQvsMEsyW+1wNSIZaWjtvAbzDurhTN87MtnzW2o2Y hOkYCsMASKzpdKWdkZZok37hzr3P9b+09swV5wnX97pNFhjhdIZMLqGiyZ4lNi+ybQVAuc96142 9ucFuOBFz2G5ABnLmflr2LVY0XbX9G9TsNzyCA+If45clcgb3BdCF0dVHUN8orOwy42w== X-Google-Smtp-Source: AGHT+IFZriRv/JASco/a5g1CgelbHZYIptVmjcE0tvfpKOw2ux6bobEMoCPE5WyE1tWDE5oKTIMqGQ== X-Received: by 2002:a05:6602:3fc1:b0:93e:7c6c:c0b6 with SMTP id ca18e2360f4ac-945c982a463mr530918139f.15.1761753080836; Wed, 29 Oct 2025 08:51:20 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id ca18e2360f4ac-94359effcefsm475208239f.11.2025.10.29.08.51.19 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 29 Oct 2025 08:51:20 -0700 (PDT) Date: Wed, 29 Oct 2025 10:51:18 -0500 From: Nathan Bossart To: Sami Imseih Cc: David Rowley , Robert Haas , Jeremy Schneider , pgsql-hackers@postgresql.org Subject: Re: another autovacuum scheduling thread Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="80LKapVVCE26vvPp" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --80LKapVVCE26vvPp Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit On Tue, Oct 28, 2025 at 05:44:37PM -0500, Sami Imseih wrote: > My compiler is complaining about v6 > > "../src/backend/postmaster/autovacuum.c:3293:32: warning: operation on > ‘*score’ may be undefined [-Wsequence-point] > 3293 | *score = *score = Max(*score, (double) > instuples / Max(vacinsthresh, 1)); > [2/2] Linking target src/backend/postgres" > > shouldn't just be like below? > > *score =Max(*score, (double) instuples / Max(vacinsthresh, 1)); Oops. I fixed that typo in v7. -- nathan --80LKapVVCE26vvPp Content-Type: text/plain; charset=us-ascii Content-Disposition: attachment; filename=v7-0001-autovacuum-scheduling-improvements.patch