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 1tpXTb-007T2p-Ii for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Mar 2025 18:58:47 +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 1tpXTa-005Dlm-BD for pgsql-hackers@arkaria.postgresql.org; Tue, 04 Mar 2025 18:58:46 +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 1tpXTZ-005Dle-UV for pgsql-hackers@lists.postgresql.org; Tue, 04 Mar 2025 18:58:46 +0000 Received: from relay4-d.mail.gandi.net ([2001:4b98:dc4:8::224]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tpXTW-000x0L-0L for pgsql-hackers@lists.postgresql.org; Tue, 04 Mar 2025 18:58:45 +0000 Received: by mail.gandi.net (Postfix) with ESMTPSA id AF4494452D; Tue, 4 Mar 2025 18:58:39 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=vondra.me; s=gm1; t=1741114720; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=xdY93KsWz3/TljgHKzNrrE0rgUjgPhqeAH6tLG0GCgs=; b=jkHKChXqN3olW2PV/OCzxi9pjaH5GdYZIi+wguXgozI9GdXkvnNuV7n1j80AhpMKU9h9hz kxVM+0pBzPndp75k5dftPcxc3WOovvpbtBp02y0N1tjPYLh4EohpwYpcczq4tIZ2mDgGND QAHX+e1MnBs/CfY2EOBu2uHPCg1/1A7WPM41EXJBLcwyMj3CKw8H4WAL76u3CI6APbrMWk GmMs3i1BcRnHuiOgqjUgqQjmmxXI4gZIl+Ufso2WBxV9NuU2cifUil/Ng0TeGMyWuRXrZ+ lnLqg9irkGNIIu/hFMqC9vnOyZJtPD4dj3b7r9V+eG8TjO07QWVy4Sur3+JN4w== Message-ID: Date: Tue, 4 Mar 2025 19:58:38 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: scalability bottlenecks with (many) partitions (and more) From: Tomas Vondra To: Andres Freund Cc: Jakub Wartak , Robert Haas , PostgreSQL Hackers References: <0775ba8a-920c-4d37-b202-989a90b6ee4c@vondra.me> <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> Content-Language: en-US In-Reply-To: <733e72fa-5fc2-48fc-ab1f-1d8f1ab387c3@vondra.me> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-GND-State: clean X-GND-Score: -100 X-GND-Cause: gggruggvucftvghtrhhoucdtuddrgeefvddrtddtgddutddvkedvucetufdoteggodetrfdotffvucfrrhhofhhilhgvmecuifetpfffkfdpucggtfgfnhhsuhgsshgtrhhisggvnecuuegrihhlohhuthemuceftddunecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjughrpefkffggfgfuhffvvehfjggtgfesthejredttddvjeenucfhrhhomhepvfhomhgrshcugghonhgurhgruceothhomhgrshesvhhonhgurhgrrdhmvgeqnecuggftrfgrthhtvghrnhepveefffeludeuheeltedvffffgfegvdeiveeuveetvefhkefgveelveehtddutdetnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfkphepkeeirdegledrvdefiedrudelfeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpeekiedrgeelrddvfeeirdduleefpdhhvghloheplgdutddrudefjedrtddrvdgnpdhmrghilhhfrhhomhepthhomhgrshesvhhonhgurhgrrdhmvgdpnhgspghrtghpthhtohepgedprhgtphhtthhopegrnhgurhgvshesrghnrghrrgiivghlrdguvgdprhgtphhtthhopehjrghkuhgsrdifrghrthgrkhesvghnthgvrhhprhhishgvuggsrdgtohhmpdhrtghpthhtoheprhhosggvrhhtmhhhrggrshesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhlqdhhrggtkhgvrhhssehlihhsthhsrdhpohhsthhgrhgvshhqlhdrohhrgh X-GND-Sasl: tomas@vondra.me List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 3/4/25 15:38, Tomas Vondra wrote: > > ... > >>> >>> Attached is a patch doing this, but considering it has nothing to do >>> with the shmem sizing, I wonder if it's worth it. >> >> Yes. >> > > OK, barring objections I'll push the v2. > Pushed, with the tweaks to use FastPathLockSlotsPerBackend() in a couple more places. I noticed sifaka started failing right after I pushed this: https://buildfarm.postgresql.org/cgi-bin/show_history.pl?nm=sifaka&br=master But I have no idea why would this cosmetic change cause issues with LDAP tests, so I'm assuming the failure is unrelated, and the timing is accidental and not caused by the patch. regards -- Tomas Vondra