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 1tpZqm-008I3e-22 for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Mar 2025 21:30:52 +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 1tpZqk-008efA-Oe for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Mar 2025 21:30:50 +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 1tpZqk-008ef2-ED for pgsql-hackers@lists.postgresql.org; Tue, 04 Mar 2025 21:30:50 +0000 Received: from sss.pgh.pa.us ([68.162.161.243]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tpZqg-000yT8-1P for pgsql-hackers@lists.postgresql.org; Tue, 04 Mar 2025 21:30:50 +0000 Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 524LUYk2193454; Tue, 4 Mar 2025 16:30:35 -0500 From: Tom Lane To: Andres Freund cc: Tomas Vondra , Andrew Dunstan , Jakub Wartak , Robert Haas , PostgreSQL Hackers Subject: Re: scalability bottlenecks with (many) partitions (and more) In-reply-to: References: <0f27b64b-5bf3-4140-98b7-635e312e1796@vondra.me> <3cebb4ab-1168-4259-8cb8-8a8ed7efeb43@vondra.me> <7c1eeafb-2375-4ff6-8469-0640d52d44ed@vondra.me> <5xahykogf2sg3ofdqk2li7xx3t2vh23m42jnvfwxoi5fhh7iya@girlhoxdxjzc> <486baeb2-2adc-48d2-ba9d-13c4ae43301c@vondra.me> <733e72fa-5fc2-48fc-ab1f-1d8f1ab387c3@vondra.me> Comments: In-reply-to Andres Freund message dated "Tue, 04 Mar 2025 14:09:24 -0500" MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-ID: <193452.1741123834.1@sss.pgh.pa.us> Content-Transfer-Encoding: quoted-printable Date: Tue, 04 Mar 2025 16:30:34 -0500 Message-ID: <193453.1741123834@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Andres Freund writes: > On 2025-03-04 19:58:38 +0100, Tomas Vondra wrote: >> I noticed sifaka started failing right after I pushed this: > It's worth noting that > a) sifaka doesn't build with ldap support > b) the failure is in checkprep, not when running the tests > c) the buildfarm unfortunately doesn't archive install.log, so it's hard= to > know what actually went wrong Yeah, I've been poking at that. It's not at all clear why the animal is trying to run src/test/modules/ldap_password_func now when it didn't before. I've been through the diffs between BF client 18 and 19 multiple times and nothing jumps out at me. What's clear though is that it *is* trying to do "make check" in that directory, and the link step blows up with ccache clang -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-afte= r-statement -Werror=3Dvla -Werror=3Dunguarded-availability-new -Wendif-lab= els -Wmissing-format-attribute -Wcast-function-type -Wformat-security -Wmi= ssing-variable-declarations -fno-strict-aliasing -fwrapv -fexcess-precisio= n=3Dstandard -Wno-unused-command-line-argument -Wno-compound-token-split-b= y-macro -Wno-cast-function-type-strict -g -O2 -fvisibility=3Dhidden -bund= le -o ldap_password_func.dylib ldap_password_func.o -L../../../../src/por= t -L../../../../src/common -isysroot /Library/Developer/CommandLineTools/= SDKs/MacOSX15.2.sdk -L/opt/local/libexec/llvm-17/lib -L/opt/local/lib -W= l,-dead_strip_dylibs -fvisibility=3Dhidden -bundle_loader ../../../../sr= c/backend/postgres Undefined symbols for architecture arm64: "_ldap_password_hook", referenced from: __PG_init in ldap_password_func.o ld: symbol(s) not found for architecture arm64 clang: error: linker command failed with exit code 1 (use -v to see invoca= tion) That happens because (a) ldap_password_hook is not defined unless USE_LDAP; (b) macOS's linker is persnickety and reports the missing symbol at shlib link time, not shlib load time. Maybe we should rethink (a)? In the meantime I'm trying to hack the script so it skips that test module, and finding out that my Perl is rustier than I thought. regards, tom lane