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 1taIh7-000abI-RZ for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Jan 2025 18:09:46 +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 1taIh6-003CQw-SD for pgsql-hackers@arkaria.postgresql.org; Tue, 21 Jan 2025 18:09:44 +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 1taIdw-0036xO-HL for pgsql-hackers@lists.postgresql.org; Tue, 21 Jan 2025 18:06:28 +0000 Received: from mail-lj1-x229.google.com ([2a00:1450:4864:20::229]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1taIdu-000luW-1g for pgsql-hackers@lists.postgresql.org; Tue, 21 Jan 2025 18:06:27 +0000 Received: by mail-lj1-x229.google.com with SMTP id 38308e7fff4ca-30167f4c1e3so54765401fa.3 for ; Tue, 21 Jan 2025 10:06:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1737482785; x=1738087585; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=fA4Tz9sVLHCQe0awwv9UfJf5q2/mVhO7tgxF10HzaKg=; b=mWvkoQ9rf5/b8NtBO7wce1ERiRJrfHyX731VvmLLWqbwzaw9Oap2V7iPnAD2IptyC+ WUOzwyRMAtBt68kGm1qNU54TYZqOGQtrYfaqygGvUkMQEEQdTf/ZcjFH8VntFI0JJseq PG79y/uezeU2pp6mfbQ9amJ5y/ehido0M7sLWTyxQVg9B8z1QReTkYVNWFOjDMhsfF06 /kydF5FYnTC8d1zfqbuH2JwiE1VnPtWhMgkV8EJLCKs8nPIGQERk15qx9CSk2cIlhDcK fcfkSZji39d3MT6LpVOv8RneNA006KHrCoEttA2ZyeF4rA9PTD0GRA3ir/zzodSwJcnt Lu7Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1737482785; x=1738087585; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=fA4Tz9sVLHCQe0awwv9UfJf5q2/mVhO7tgxF10HzaKg=; b=v5iAftU/r8XRjoQPbRHxI+o4SMVoxacnknZwOQkSMRejjjQVSWV/KBriLaEzh0vWE4 3w0i65fPBS0kzsu8HI96bno2+rur0tMQk4gGEZgKfahTNSuy6ry+9oMRzgyaOc2hF4VT nl78I2qj6owIjMvqdRlkU6l+95nWed4Bq/ah/GyF+50TKwyX4F2+BvLCb3z1lqu0xsEv y11bZudGPqNpw55hIcieLHIJxSUrgsvx/N87vOdbMC7ZRSyg2Ogf32RlSAs89pUVD5om s+6T70tZfOB344t8J19EqbCh+SoqWvusLrDv4gXhuxCahwD7IP0ofEDeBdKvr5r8NNOs WDEQ== X-Forwarded-Encrypted: i=1; AJvYcCXJTa8OPllZ7YxAQo96kDCJCsDm+SFnYEyOprcdGT0FRsZeOGrajxwA71RDkr9UJml8w43yT0KkurniGLHJ@lists.postgresql.org X-Gm-Message-State: AOJu0YzcISAGXYARFDq5Gk4LwpPgmNrlkfU/BFmXd5B8wTUFPkVkhcUD 7I/b563oYURnNKYTvHm2+hXw4UZzSUbn0r9bNWWSXkQOpd1ZtdEu/95cBAyn8UBvAoic05dJPa8 q7x+IY2gqP8KNctSnAwnuzE/SskQ= X-Gm-Gg: ASbGnctEjo8/Dr0sPHd5czIgdeziaQ4TcAjLgxErhrqd4xHImYZqlAl/wCjF9Y973Hk Ism2QokgVRWHiVto1eQIufyg2evgKIjB45UDXUwWZINWCghqu X-Google-Smtp-Source: AGHT+IFvvktt2vS8p+8Ydqi2wv3yDvXm+lOTk4e6BAFggkMknyUWBo7CSxp02u1oswVgjEsQbXlVcjEUEYcigyT2foM= X-Received: by 2002:a05:651c:896:b0:300:1947:a28c with SMTP id 38308e7fff4ca-3072cb66472mr80443951fa.26.1737482785051; Tue, 21 Jan 2025 10:06:25 -0800 (PST) MIME-Version: 1.0 References: <1342498.1729444411@sss.pgh.pa.us> <1445998.1729482404@sss.pgh.pa.us> <2062830.1729625620@sss.pgh.pa.us> <2265411.1729699470@sss.pgh.pa.us> <2354718.1729737539@sss.pgh.pa.us> <2581216.1729794746@sss.pgh.pa.us> <1948345.1730500073@sss.pgh.pa.us> <3797606.1732045516@sss.pgh.pa.us> <647219.1736019347@sss.pgh.pa.us> <1417389.1736964543@sss.pgh.pa.us> In-Reply-To: <1417389.1736964543@sss.pgh.pa.us> From: Michel Pelletier Date: Tue, 21 Jan 2025 10:05:48 -0800 X-Gm-Features: AbW1kvZ-oOCI8mij5AeNAIOO2mxHzudxgg0U1MLW2UpoQbyAE9Q_PW4qIobkpnA Message-ID: Subject: Re: Using Expanded Objects other than Arrays from plpgsql To: Tom Lane Cc: Pavel Stehule , pgsql-hackers@lists.postgresql.org Content-Type: multipart/alternative; boundary="00000000000034df9d062c3b3c9c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000034df9d062c3b3c9c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Jan 15, 2025 at 10:09=E2=80=AFAM Tom Lane wrote= : > I noticed that v2 of this patch series failed to apply after > 7b27f5fd3, so here's v3. No non-trivial changes. > Thanks Tom! These applied cleanly to my test env and actually increased my livejournal graph benchmark by a million edges per second, so I guess I didn't have all the previous changes in my last build as you noted. -Michel --00000000000034df9d062c3b3c9c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Jan 15, 2025 at 10:09=E2=80=AFAM = Tom Lane <tgl@sss.pgh.pa.us>= wrote:
I noticed that v2 of this patch series= failed to apply after
7b27f5fd3, so here's v3.=C2=A0 No non-trivial changes.
=

Thanks Tom!=C2=A0 These applied cleanly to my test env = and actually increased my livejournal graph benchmark by a million edges pe= r second, so I guess I didn't have all the previous changes in my last = build as you noted.=C2=A0

-Michel
--00000000000034df9d062c3b3c9c--