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 1uviFc-000E9s-6W for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Sep 2025 20:14: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 1uviFa-007UZ6-Qq for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Sep 2025 20:14: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 1uviFa-007UYy-Ge for pgsql-hackers@lists.postgresql.org; Mon, 08 Sep 2025 20:14:06 +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 1uviFZ-001DVK-0V for pgsql-hackers@postgresql.org; Mon, 08 Sep 2025 20:14:06 +0000 Received: by mail-il1-x12e.google.com with SMTP id e9e14a558f8ab-40809f7ffc7so5745845ab.3 for ; Mon, 08 Sep 2025 13:14:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1757362444; x=1757967244; darn=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=StS7ZnCivSChuZ8DqPgKBAjP7uloPu2YSCdc9dZd4Xs=; b=jl2j/qgteHUFM4oIK/+7hR/iUBivlR6Ka3cWYxQxj3cgutzUDVpFJLgG959coz5czl TUP6KHG4BVdcH8w1PkEON+tHNNRScjzV180BPVSHDJ1DPlxPIlcJOjX4JX4gNAU0wvYt Zufxth7kZCwfS6gcMMW3BV6uZrq/3qn9eTVfloHnhjxulvBdcdjLBquW6JI7V4iuRyDe DfOx+3eeYLc/eH8VYjtylMvq4jx0Cq2JWX5VT1yekD6hF1dhPzmXyGj6AfxjI5wuA68b vY+nCheCEu8Fb84sHdBU4o4onEH4TnNuKHMKi5lF4EuvuNf7wnSwCLHkCzAKnjqS0mTU kP3w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1757362444; x=1757967244; 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=StS7ZnCivSChuZ8DqPgKBAjP7uloPu2YSCdc9dZd4Xs=; b=Y/sjEKZQPy5AeplTKY5mEsKQfZt/ZWNpJTGM6mL9ZtfePBXINDCGczuzay7ovKLZM2 N3fDITJlYhfqVstXvCbkuLdVnV3zpvuHhFc12UFbo0hk12eZzvokJaorGEo3zrG8oIdR UygEMObeS1A+uyeVYMQ25KtOP5J7cGKTYpxZ6Tm2IA+FUfg+j1HVHf/Alw9W6f/nNaxy 6Sd4os45O2/44VoTgrKMy6jlsJ3JXv8Q8xh7fJpzax5wlWUdI3W/saWZDLsNfSihmffC 6VqRWALolwXxHV4zsFlHDJGPIeq8+3jcn/zSLYWjwil3sPuuXmZVkFQt/bUt+Zsbt0Ug 7fGA== X-Forwarded-Encrypted: i=1; AJvYcCXssXhMO6Kjqao3N6yvqt6pfLq/PvEOiQNFMrzOkmr5RBtyaH6NkXqlJdwftAkuq8p4ROs+x96EmW1uaTfJ@postgresql.org X-Gm-Message-State: AOJu0Yw4PsyJ8V0Gyw+x2pf4LrWeEO2jN053eYoPB76xXQqPCrrhzVHh meDqPoBd5hdpq/0X4k3z61XkWf69qKMRAs1HIl5y+iVOqfjzoTPTxnnncS+hcw== X-Gm-Gg: ASbGncsOH8WSc7799ACHb0pKDYjn16RsvsqI1CgYGQUpFkVVta2ixeRLkH5jZkKo7eQ DMpKYvP3H8DSSFMpCA874XrIyq87A7/pqvij+/dg52MgLjAa317wa9aUt8C9LZnEP8N08/GKC9b ZJHEwFHSHCA8KGGSQJ7l4tjXU7uFy+qX1eV5qnbtM0+CQSRqhYTidIsduKVnQiA9bE3cYrzRdrP +Z6fu/Hu+nj9aEF6MLHVfcFm01uHY4UykWRQTcGMVmVTfn/cFprrFYNBLFWCZ3ULRGYS7gmgHUO TZlc1wajtv3hCfhF6iO3TqEmLxRwgFCJ/ZD1JYdFr47WQ+G6SmVcuR98Q43g6TTbZ3fIivmpkRA 4VyqJav9ZkZIg/YnNaIKA56SFWNPfm6nrCZbPELanGGLNi5JqgGHYiOArIzNSUEF37gqSMm6cXp k6DFhNK+XGGY2UKx45kSdKYdw= X-Google-Smtp-Source: AGHT+IFc6LrZj0B429Rve916E5wCCTF059LGJ+d1lu6Z8aFNR3611x1lsxvXRTVrBzrY6D9207MCBg== X-Received: by 2002:a05:6e02:398f:b0:403:c8eb:8782 with SMTP id e9e14a558f8ab-403c8eb88eamr102791925ab.25.1757362443761; Mon, 08 Sep 2025 13:14:03 -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-5103ba7ba7dsm4937923173.12.2025.09.08.13.14.03 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 08 Sep 2025 13:14:03 -0700 (PDT) Date: Mon, 8 Sep 2025 15:14:01 -0500 From: Nathan Bossart To: Andres Freund Cc: Jeff Davis , pgsql-hackers@postgresql.org Subject: Re: Should io_method=worker remain the default? Message-ID: References: <1b50102876dc9564049c985cff0ec1903cc8d502.camel@j-davis.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 Mon, Sep 08, 2025 at 01:43:45PM -0400, Andres Freund wrote: > On 2025-09-05 16:07:09 -0700, Jeff Davis wrote: >> On Fri, 2025-09-05 at 13:25 -0700, Jeff Davis wrote: >>> As an aside, I'm building with meson using -Dc_args="-msse4.2 -Wtype- >>> limits -Werror=missing-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. > > Yes, that's an oversight. > >> 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. > > Yes, we should do this - the patch looks good to me. I think we need to do something similar for numeric.c. diff --git a/src/backend/utils/adt/meson.build b/src/backend/utils/adt/meson.build index dac372c3bea..7d0688ddb87 100644 --- a/src/backend/utils/adt/meson.build +++ b/src/backend/utils/adt/meson.build @@ -1,5 +1,14 @@ # Copyright (c) 2022-2025, PostgreSQL Global Development Group +numeric_backend_lib = static_library('numeric_backend_lib', + 'numeric.c', + dependencies: backend_build_deps, + kwargs: internal_lib_args, + c_args: vectorize_cflags, +) + +backend_link_with += numeric_backend_lib + backend_sources += files( 'acl.c', 'amutils.c', @@ -61,7 +70,6 @@ backend_sources += files( 'network_gist.c', 'network_selfuncs.c', 'network_spgist.c', - 'numeric.c', 'numutils.c', 'oid.c', 'oracle_compat.c', -- nathan