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 1uufWX-00F1cL-U3 for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Sep 2025 23:07:19 +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 1uufWW-00B08g-TG for pgsql-hackers@arkaria.postgresql.org; Fri, 05 Sep 2025 23:07:17 +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 1uufWW-00B08Y-Fi for pgsql-hackers@lists.postgresql.org; Fri, 05 Sep 2025 23:07:17 +0000 Received: from mail-pg1-x536.google.com ([2607:f8b0:4864:20::536]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uufWS-000n1W-2H for pgsql-hackers@postgresql.org; Fri, 05 Sep 2025 23:07:16 +0000 Received: by mail-pg1-x536.google.com with SMTP id 41be03b00d2f7-b52196e8464so505940a12.3 for ; Fri, 05 Sep 2025 16:07:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20230601.gappssmtp.com; s=20230601; t=1757113631; x=1757718431; darn=postgresql.org; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:from:to:cc:subject:date:message-id:reply-to; bh=xjWdv/s5QRPzyu0PbmG+D9lz/1yDh0m+ZMvemOaI6qM=; b=0O4B+OfmOoKh+bkZh3U0LDFjaXJZOOsJaIh5qn+IRn08sEaUAQKW75HJVVmAn+zaod W1loFIg8JYmT8JZQMdBJAr46yhw8CnEwlYRqed3BFVxc09Q81vTzcfCDrvgDxKk5qyNe Q2WT+3REdVbG1mcPWSjG3ocr1VinoobuUwz6gzfTdRY0ITTnoA4T62Opano0WrKpg27N aoS0TuKhnN620xrD/qB8+TzB9Kncp4znrfiK4ms2C8bhAoWqukMZtBstw+9Htt4DdUr4 zRJhpq8OKlUz05Kt1ALokjOFVF+HRC2xgBzbBHSqVkVemkN0SoB5hQLVmceakHdt7OCG Ow/Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757113631; x=1757718431; h=mime-version:user-agent:references:in-reply-to:date:cc:to:from :subject:message-id:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=xjWdv/s5QRPzyu0PbmG+D9lz/1yDh0m+ZMvemOaI6qM=; b=VXXaPTl24ipPU1vlIeXT1H0sC4wyWcFTpcI1aToPVNOg8GJs2kh+fAPXroGK3GVRHK 3JYQb86ycMBPIVpcKzZj3NKh42tAaOXK0dz/NDcpUnJgBnCwuKTsY7E9RF1aaQb1iPui siZzsqzyCgT2dBHxwqQkCPQhkiUGa+rLUqNJhuucY0Ona+aeCaJoicGy4EERQnDdLdOl tswPad2bdI7fTN+OOeT1co76Zp+IRL0zNivOdDGRvZsGG4zyWmAHx1npqMVEFcMNwJPt t1eJCb4yESaC5DI13GBC6P5AjshkGjtEZ1rv36XV34OaJG67dyoAL63oCyH8tyWktt6Y vNeQ== X-Gm-Message-State: AOJu0YzZfbMkOTe4k4alq5SIVKMn6GdnhYQy93KKshHnaaoJMOq4C90m xP+MvMfYJKmBD0eKS1TVe6LtRs53euSn6trd9X5uFq9CD0K6xjgcWKy7EVFDFGgDFtXGjdKPa2L iW5g= X-Gm-Gg: ASbGncsbVvf8dfMMHT+wi1hxDZyxUKUDhXxV42+XQLEyBsUscmi46xZbs8H98WHfKGU 9Bkml6xcSbBSnECEXffbVkVN82VcrUD1Zol4cGlRMJiME+bTImVlMVXuloKp0/Fs+tQ34MLHw1Q P/JG+eIVu3busEJJleDbu0MvBiPsIakyUi5Uk2HhIFL8NZNophQyPQzp6ww0+Q+6B8J/+5YUanH dwo0C1/+ztJTuzwycoVnSic4Oyig0HDH7qH6Zv+B4Y7/EGtpS8LQyz6sJ8nLX8P5qqd/l6z2NrW iZkxQxgibytxKt70nNveuSTkHoPu6PNwIa6e06yBCvPYW1a+h5oC9GKZNWjndNws7n5U2KvIk4Z ehewRZo9ZmnIZn5CwQ6HvQx3uaMK+Ze3+lQLyqmlCb4FcYbe5/tgUP6rHfbCcnVoYJKUgfZR2ZG v86zc= X-Google-Smtp-Source: AGHT+IHYu4vK+JF/LPlBUwxJQXqqK3T077OL2pPcjtTlsDdos2c/nstd1I22+kW4f26nlqjJlQ8H8Q== X-Received: by 2002:a17:903:2b04:b0:246:cc24:3934 with SMTP id d9443c01a7336-2516dbf1e5amr4996955ad.1.1757113631272; Fri, 05 Sep 2025 16:07:11 -0700 (PDT) Received: from jeff-ws-bridge.lan (c-76-102-242-158.hsd1.ca.comcast.net. [76.102.242.158]) by smtp.gmail.com with ESMTPSA id d9443c01a7336-24afcbf0268sm124419975ad.8.2025.09.05.16.07.10 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 05 Sep 2025 16:07:10 -0700 (PDT) Message-ID: <1b50102876dc9564049c985cff0ec1903cc8d502.camel@j-davis.com> Subject: Re: Should io_method=worker remain the default? From: Jeff Davis To: Andres Freund Cc: pgsql-hackers@postgresql.org Date: Fri, 05 Sep 2025 16:07:09 -0700 In-Reply-To: References: Content-Type: multipart/mixed; boundary="=-4yhfhPE8zwn4QIqG4/5c" User-Agent: Evolution 3.52.3-0ubuntu1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --=-4yhfhPE8zwn4QIqG4/5c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Fri, 2025-09-05 at 13:25 -0700, Jeff Davis wrote: > As an aside, I'm building with meson using -Dc_args=3D"-msse4.2 -Wtype- > limits -Werror=3Dmissing-braces". But I notice that the meson build > doesn't seem to use -funroll-loops or -ftree-vectorize when building > checksums.c. Is that intentional? If not, perhaps slower checksum > calculations explain my results. Attached a patch. I'm not sure if it's the right way to do things, but the resulting compiler command seems right to me. It doesn't affect my tests in this thread much, but it seems best to be consistent with autoconf. Regards, Jeff Davis --=-4yhfhPE8zwn4QIqG4/5c Content-Disposition: attachment; filename*0=v1-0001-meson-build-checksums-with-extra-optimization-fla.pat; filename*1=ch Content-Type: text/x-patch; name="v1-0001-meson-build-checksums-with-extra-optimization-fla.patch"; charset="UTF-8" Content-Transfer-Encoding: base64 RnJvbSBkNzE0ZTkzYWE3ZDI0OTNlMzk0NjU5MTQyYmJkM2YzNzhhYTBmMDUwIE1vbiBTZXAgMTcg MDA6MDA6MDAgMjAwMQpGcm9tOiBKZWZmIERhdmlzIDxqZWZmQGotZGF2aXMuY29tPgpEYXRlOiBG cmksIDUgU2VwIDIwMjUgMTU6NDE6MzUgLTA3MDAKU3ViamVjdDogW1BBVENIIHYxXSBtZXNvbjog YnVpbGQgY2hlY2tzdW1zIHdpdGggZXh0cmEgb3B0aW1pemF0aW9uIGZsYWdzLgoKVXNlIC1mdW5y b2xsLWxvb3BzIGFuZCAtZnRyZWUtdmVjdG9yaXplIHdoZW4gYnVpbGRpbmcgY2hlY2tzdW0uYyB0 bwptYXRjaCB3aGF0IGF1dG9jb25mIGRvZXMuCgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5l cy9tL2E4MWYyZjdlZjM0YWZjMjRhODljNjEzNjcxZWEwMTdlMzY1MTMyOWMuY2FtZWxAai1kYXZp cy5jb20KLS0tCiBzcmMvYmFja2VuZC9zdG9yYWdlL3BhZ2UvbWVzb24uYnVpbGQgfCAxMCArKysr KysrKystCiAxIGZpbGUgY2hhbmdlZCwgOSBpbnNlcnRpb25zKCspLCAxIGRlbGV0aW9uKC0pCgpk aWZmIC0tZ2l0IGEvc3JjL2JhY2tlbmQvc3RvcmFnZS9wYWdlL21lc29uLmJ1aWxkIGIvc3JjL2Jh Y2tlbmQvc3RvcmFnZS9wYWdlL21lc29uLmJ1aWxkCmluZGV4IGMzZTRhODA1ODYyLi4xMTJmMDBm ZjM2NSAxMDA2NDQKLS0tIGEvc3JjL2JhY2tlbmQvc3RvcmFnZS9wYWdlL21lc29uLmJ1aWxkCisr KyBiL3NyYy9iYWNrZW5kL3N0b3JhZ2UvcGFnZS9tZXNvbi5idWlsZApAQCAtMSw3ICsxLDE1IEBA CiAjIENvcHlyaWdodCAoYykgMjAyMi0yMDI1LCBQb3N0Z3JlU1FMIEdsb2JhbCBEZXZlbG9wbWVu dCBHcm91cAogCitjaGVja3N1bV9iYWNrZW5kX2xpYiA9IHN0YXRpY19saWJyYXJ5KCdjaGVja3N1 bV9iYWNrZW5kX2xpYicsCisgICdjaGVja3N1bS5jJywKKyAgZGVwZW5kZW5jaWVzOiBiYWNrZW5k X2J1aWxkX2RlcHMsCisgIGt3YXJnczogaW50ZXJuYWxfbGliX2FyZ3MsCisgIGNfYXJnczogdmVj dG9yaXplX2NmbGFncyArIHVucm9sbF9sb29wc19jZmxhZ3MsCispCisKK2JhY2tlbmRfbGlua193 aXRoICs9IGNoZWNrc3VtX2JhY2tlbmRfbGliCisKIGJhY2tlbmRfc291cmNlcyArPSBmaWxlcygK ICAgJ2J1ZnBhZ2UuYycsCi0gICdjaGVja3N1bS5jJywKICAgJ2l0ZW1wdHIuYycsCiApCi0tIAoy LjQzLjAKCg== --=-4yhfhPE8zwn4QIqG4/5c--