Date: Fri, 3 Dec 2021 16:35:08 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Robert Haas <robertmhaas@gmail.com>
Cc: James Coleman <jtc331@gmail.com>,
	pgsql-hackers <pgsql-hackers@postgresql.org>,
	Amit Kapila <amit.kapila16@gmail.com>, Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Parallelize correlated subqueries that execute within each worker
Message-ID: <YanIrCPfvgfITO5R@paquier.xyz>
References: 
 <CAAaqYe_x1u3V4uPiv=dJ=k2EJ7txhdq6yexJDkYZ1x1pu0QwcQ@mail.gmail.com>
 <CA+TgmobtK2OnhNaKbq8Q+k217mCUdpLFeMXTjxr6QZMG3KE5Gw@mail.gmail.com>
 <CAAaqYe-FYVq=CSZu8VtKi0fx8Zdi6fzyzEP2B9iK2cUgY8xGjA@mail.gmail.com>
 <CA+TgmoaAPfPcQx0uYLusU4A+Vm5Cr2F8irxo=xf8BQ-97YyZ7A@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="jBJueCGm4hgBjP8h"
Content-Disposition: inline
In-Reply-To: 
 <CA+TgmoaAPfPcQx0uYLusU4A+Vm5Cr2F8irxo=xf8BQ-97YyZ7A@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YanIrCPfvgfITO5R%40paquier.xyz>
Precedence: bulk


--jBJueCGm4hgBjP8h
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Mon, Nov 15, 2021 at 10:01:37AM -0500, Robert Haas wrote:
> On Wed, Nov 3, 2021 at 1:34 PM James Coleman <jtc331@gmail.com> wrote:
>> As I understand the current code, parallel plans are largely chosen
>> based not on where it's safe to insert a Gather node but rather by
>> determining if a given path is parallel safe. Through that lens params
>> are a bit of an odd man out -- they aren't inherently unsafe in the
>> way a parallel-unsafe function is, but they can only be used in
>> parallel plans under certain conditions (whether because of project
>> policy, performance, or missing infrastructure).
>=20
> Right.

Please note that the CF bot is complaining here, so I have moved this
patch to the next CF, but changed the status as waiting on author.
--
Michael

--jBJueCGm4hgBjP8h
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmGpyKwACgkQnvQgOdby
QH1L7g/+KI2CjmoIqoYhFFYA+leKAzvHuWQ6qefJOH+byyqGcE1NXw1f8Up79GD3
6WpbFPsZNZ3tGAN/cnghiMmT828egi/72ov/1P/+kDqPGdVAOyAH9KZMgpmDd/02
aev4ltpASfsav5yY0lgXlq/MPGGF5p85syR+KkcwUwazBAXyFokfWKnhOvbWy7Oz
tAsL8+QHG1sFqwTP1Abc+hzvdvJvBmHZnahL1bLAY8iPo+Jy1krvriLNldlp5KiC
kGo2+JYTZXWJmTDb8PN5OJABPuc1FiSsBRQ5R1buhMN4foxr8xsooAUhfrZ7pV11
w0nZZ5EXjVcBcZ3jzvd4kYWQaDMnDjKi1iBKuQR61GxpZ9Yr+2LJz3xcDdAaL1uM
JsvCyzd934ZvE9QDt+Va3Grjl65PibAwZiOY9o7d7Qx7eNYkst5PlgbctHm2TBzs
3qEy/tTYiX67wmamffs9t+1fQngpEW3voDBPXUdLRZmY3Pum/U9qi6kSKl+hYw1T
tf1I6xeCnGjyg+vIwHOTT/lHNW9mIITNEXFHaHvZXoZBEDxE/kyWKGy1Mmhg0jfG
rUvySD63pSrwH2ajRJOWteac1kkODHcGCdC7+IBGSijIXbF6BBqZmvA9vfV8Dn0R
wIt7WwHEQBsi6N5OEEk1Je/OIZUL0xEUrx10r+3lDjIGDgw97Wo=
=Rbt/
-----END PGP SIGNATURE-----

--jBJueCGm4hgBjP8h--