Subject: Re: postgres_fdw: perform UPDATE/DELETE .. RETURNING on a join
 directly
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>,
 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>,
 Robert Haas <robertmhaas@gmail.com>,
 Pg Hackers <pgsql-hackers@postgresql.org>,
 Rushabh Lathia <rushabh.lathia@gmail.com>,
 Michael Paquier <michael.paquier@gmail.com>
References: <5A438A45.2000909@lab.ntt.co.jp>
 <CA+Tgmobf+AXEwO4r0oCkvNhkaVnxPgoJaApoX+rAi0G7-N-Dyg@mail.gmail.com>
 <5A7CFDDA.8050906@lab.ntt.co.jp> <5A7D76CF.8080601@lab.ntt.co.jp>
 <CA+TgmoaAQCn0+xh3JG2avn35Lukj2NVmhxVi7hE2CwzSUQ-5ag@mail.gmail.com>
 <20134.1518201188@sss.pgh.pa.us>
 <CA+TgmoY5KNf-Y=zOdHVfa8Lmo=OMJe=dBpP-noT_1fdVK6EYPA@mail.gmail.com>
 <18653.1518297871@sss.pgh.pa.us> <5A82DCCE.3060107@lab.ntt.co.jp>
 <29147.1519769644@sss.pgh.pa.us>
 <CA+Tgmob_WGK+vKzE6FmrMmuwuv4myntfRAkEbo+tsDt9xUwCLQ@mail.gmail.com>
 <23783.1519929258@sss.pgh.pa.us> <5A9928F1.2010206@lab.ntt.co.jp>
 <CA+TgmoaNWpQ+F7_DtiJpc62PUJ6JQBAQpT1H7CBrjKmryGGgkw@mail.gmail.com>
 <CA+TgmoZOpGnmss2dpOAktHc30NS=StmLw-ChkJkd74DLo_nyEA@mail.gmail.com> <! !
 5A9CB7B9.2040008@lab.ntt.co.jp>
 <CAFjFpRdQVqCrYXN3F=jj_wftSp2gD-rPXKS-ogoQLAmrmKxwuQ@mail.gmail.com>
 <21358.1520229112@sss.pgh.pa.us> <25502.1520277552@sss.pgh.pa.us>
 <857d2c90-492a-028e-37b9-66d86d8! cd5dc@joeconway.com>
 <22164.1520287630@sss.pgh.pa.us>
From: Joe Conway <mail@joeconway.com>
Openpgp: id=4EA5B4659ED59CC9538139A5332B7E68B699434A
Message-ID: <f2bd9e72-93bf-1a84-e898-d915b5f50ccf@joeconway.com>
Date: Mon, 5 Mar 2018 14:56:29 -0800
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101
 Thunderbird/52.6.0
MIME-Version: 1.0
In-Reply-To: <22164.1520287630@sss.pgh.pa.us>
Content-Type: multipart/signed; micalg=pgp-sha256;
 protocol="application/pgp-signature";
 boundary="MHBqKYWZvVPJZU6fpV706tlZ3n08KQgrE"
Precedence: bulk

This is an OpenPGP/MIME signed message (RFC 4880 and 3156)
--MHBqKYWZvVPJZU6fpV706tlZ3n08KQgrE
Content-Type: multipart/mixed; boundary="w3Yce6tgl8xpn7fRBgsXiesIC8X5wrMwr";
 protected-headers="v1"
From: Joe Conway <mail@joeconway.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>,
 Etsuro Fujita <fujita.etsuro@lab.ntt.co.jp>,
 Robert Haas <robertmhaas@gmail.com>,
 Pg Hackers <pgsql-hackers@postgresql.org>,
 Rushabh Lathia <rushabh.lathia@gmail.com>,
 Michael Paquier <michael.paquier@gmail.com>
Message-ID: <f2bd9e72-93bf-1a84-e898-d915b5f50ccf@joeconway.com>
Subject: Re: postgres_fdw: perform UPDATE/DELETE .. RETURNING on a join
 directly
References: <5A438A45.2000909@lab.ntt.co.jp> <5A7BE8E6.200@lab.ntt.co.jp>
 <28606.1518105934@sss.pgh.pa.us>
 <CA+Tgmobf+AXEwO4r0oCkvNhkaVnxPgoJaApoX+rAi0G7-N-Dyg@mail.gmail.com>
 <5A7CFDDA.8050906@lab.ntt.co.jp> <5A7D76CF.8080601@lab.ntt.co.jp>
 <CA+TgmoaAQCn0+xh3JG2avn35Lukj2NVmhxVi7hE2CwzSUQ-5ag@mail.gmail.com>
 <20134.1518201188@sss.pgh.pa.us>
 <CA+TgmoY5KNf-Y=zOdHVfa8Lmo=OMJe=dBpP-noT_1fdVK6EYPA@mail.gmail.com>
 <18653.1518297871@sss.pgh.pa.us> <5A82DCCE.3060107@lab.ntt.co.jp>
 <29147.1519769644@sss.pgh.pa.us>
 <CA+Tgmob_WGK+vKzE6FmrMmuwuv4myntfRAkEbo+tsDt9xUwCLQ@mail.gmail.com>
 <23783.1519929258@sss.pgh.pa.us> <5A9928F1.2010206@lab.ntt.co.jp>
 <CA+TgmoaNWpQ+F7_DtiJpc62PUJ6JQBAQpT1H7CBrjKmryGGgkw@mail.gmail.com>
 <CA+TgmoZOpGnmss2dpOAktHc30NS=StmLw-ChkJkd74DLo_nyEA@mail.gmail.com> <! !
 5A9CB7B9.2040008@lab.ntt.co.jp>
 <CAFjFpRdQVqCrYXN3F=jj_wftSp2gD-rPXKS-ogoQLAmrmKxwuQ@mail.gmail.com>
 <21358.1520229112@sss.pgh.pa.us> <25502.1520277552@sss.pgh.pa.us>
 <857d2c90-492a-028e-37b9-66d86d8! cd5dc@joeconway.com>
 <22164.1520287630@sss.pgh.pa.us>
In-Reply-To: <22164.1520287630@sss.pgh.pa.us>

--w3Yce6tgl8xpn7fRBgsXiesIC8X5wrMwr
Content-Type: text/plain; charset=utf-8
Content-Language: en-US
Content-Transfer-Encoding: quoted-printable

On 03/05/2018 02:07 PM, Tom Lane wrote:
> So you can revert the rhinoceros config change if you like --- thanks
> for making it so quickly!

Ok, reverted.

> Meanwhile, I'm back to wondering what could possibly have affected
> the planner's estimates, if pg_proc and pg_statistic didn't change.
> I confess bafflement ... but we've now eliminated the autovacuum-
> did-it theory entirely, so it's time to start looking someplace else.
> I wonder if something in the postgres_fdw remote join machinery
> is not as deterministic as it should be.

Do you want me to do anything manual locally on this VM?

Joe

--=20
Crunchy Data - http://crunchydata.com
PostgreSQL Support for Secure Enterprises
Consulting, Training, & Open Source Development


--w3Yce6tgl8xpn7fRBgsXiesIC8X5wrMwr--

--MHBqKYWZvVPJZU6fpV706tlZ3n08KQgrE
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2

iQIcBAEBCAAGBQJancseAAoJEDfy90M199hlOK8P/3a2fz6UB+/t9g3VIptVbxcv
NqtyDEQR7SpDnyY3SjhHEntQadFYB5LOn5hGwfK3wlbywSX5UIvnVwf2qkS5lwnT
cKFqpywkIsQjye+bCaup/TX488xtXRxtkLD9X/rdiSirYTGAvE4QPrev6ldkBVWW
1ydDGcXBm4E5HycN+3+N2lXXng9/Hche93UYp0cKx+KRwY2vPVzHBWJ3gEUE7ArN
EyjJ6gTm2ghezxN+ztb0/sm4u3/jIwf12S/ECZRcV6Yfu+yCHuWcXFkSVtyxBcbT
42bSFfrGtMS35lNWLZ39rjxHXHDDACAjLwAOta4j861gNDp1DCY647cTqv02UeWo
6y7/DjUo7i40HunSGvR0Mr2tXqLOXM60LVeS/65GCZgk/NmKV8wfMslN53Tn3T2Y
zoh1p6do4xE5g7g23LGddlhXgpdRWpBg7UdbQd2mMm93I+OYL6866zzj82YrOl/E
mae4+EhHB6udNQoIwIt1ilTCmaIiUboeG0ZAn2aRceieX8OMT9sBlsVyGa2VGu4J
I9coUOJBN86FkWYd++qQ2av4m/VGbQAAB86UzcUkh6ktr15+ocJ5+tZitmX532GW
X4ChvXvDHjRb2ruF6a+m7FptmP39NnGXveSKpd3uA/EN3ICiPBeaBFGeBVhbUiu5
TeqyWXYghrKI/l0xAGGA
=Ar+r
-----END PGP SIGNATURE-----

--MHBqKYWZvVPJZU6fpV706tlZ3n08KQgrE--