Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.92)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1j72Cl-0000sJ-Us
	for pgsql-performance@arkaria.postgresql.org; Wed, 26 Feb 2020 19:18:48 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-performance-owner+archive@lists.postgresql.org>)
	id 1j72Ck-0001ZK-AP
	for pgsql-performance@arkaria.postgresql.org; Wed, 26 Feb 2020 19:18:46 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <michaeldba@sqlexec.com>)
	id 1j72Cj-0001ZD-Tu
	for pgsql-performance@lists.postgresql.org; Wed, 26 Feb 2020 19:18:46 +0000
Received: from mout.perfora.net ([74.208.4.197])
	by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128)
	(Exim 4.92)
	(envelope-from <michaeldba@sqlexec.com>)
	id 1j72Cg-0000Yd-Ot
	for pgsql-performance@postgresql.org; Wed, 26 Feb 2020 19:18:44 +0000
Received: from [IPv6:2607:fb90:a83e:a0f0:91b4:f441:50bf:7423]
 ([172.58.187.235]) by mrelay.perfora.net (mreueus004 [74.208.5.2]) with
 ESMTPA (Nemesis) id 1MnJ28-1jnp9D1E1s-00jEd4; Wed, 26 Feb 2020 20:18:35 +0100
Content-Type: multipart/alternative;
 boundary=Apple-Mail-81BAAA59-CA2A-45F8-99DB-067B3D9DA137
Content-Transfer-Encoding: 7bit
From: "MichaelDBA@sqlexec.com" <michaeldba@sqlexec.com>
Mime-Version: 1.0 (1.0)
Subject: Re: much slower query in production
Date: Wed, 26 Feb 2020 14:18:31 -0500
Message-Id: <69844C34-DF13-46E6-BE7C-C9DABE19D391@sqlexec.com>
References: 
 <CAHOFxGp9K3LHR8ejzDvMyNNv9WmpyyA6CvctZGTeh3iJ38kcwg@mail.gmail.com>
Cc: Guillaume Cottenceau <gc@mnc.ch>,
 postgres performance list <pgsql-performance@postgresql.org>
In-Reply-To: 
 <CAHOFxGp9K3LHR8ejzDvMyNNv9WmpyyA6CvctZGTeh3iJ38kcwg@mail.gmail.com>
To: Michael Lewis <mlewis@entrata.com>
X-Mailer: iPhone Mail (17D50)
X-Provags-ID: V03:K1:XkmJs5PFXs9KNfOITC7r1JBj0E0xiLVdr5S1mjkTmg+EMTmDghv
 1DJ1HrjSA5G35jCX+ZFztGXNgnQkUs2tKN9svfXaUzZL4R35YsmIclAxMkcaZq3fwyMPu9+
 DZM4J1+mnALbAz0PS8DfUUOF6A6oHcsx6tB0H8vDKik+Xzueoqtj0jdu/8h9JXtwTyizebH
 41b8a7hnan7tFmbZ6jsDg==
X-Spam-Flag: NO
X-UI-Out-Filterresults: notjunk:1;V03:K0:5IptvMfjKjk=:uQ9fxkj01vQF91wjig44IX
 LAYtOpxtxEdMOdKVu7amvQ6Pd/2GqgTgBwOLGuLrmG3Md3EcE+8lziIclLgCxiM+fcU0R3oqM
 lukSglmHC091d6EvCKofQLdeJjSDsFiL4QjhASNLNF4F7IrG5FDxW0mV1si4fbqMyqiLvkx3k
 K+dv+BVK90pFJJVgXC5n1bYbPoUqgDBSYNk6xwmBrsb8APV9bSRqloUEwHkTd3EZQY8akbvcG
 3Wy/tIDWvMA0CAGf/zEXztFNmWTzQLjISijZCGxpNIIpSHZekdipOyzs11c7i0WSOzBVrnYCw
 UMiCR2EHXZjiFjToKKFvM1JRfnLmUP40449o/UdFEdy67bAK7EToTvd4wLl/e1DqzHuA9nEn0
 PpKA+M7jUQHfqYEiwT1D2ecXtEGY2LydNodESNirde/2OK9yVYQoOgfnrIBI8Oy4xalQzzUMv
 7tR+KN2CKfUf9PoFxu92sJp6tgihGT2IKpalYn/eTAvioUTUOnsO3Lr2nF4+3Uu6MORSogMhu
 qCK3F4Olpzfkd+UAdsUS9azvhtuL7X3KkQcbt/no3GbTs0WPyd5OEkx/gLhgtRzjRWWAk/cAy
 sJX32JzHz9UQTpFkANnNArQ+Q+gPos2+QgO1oMbQXi851w7DVg7dQAxz2H6dIYdRWu8NPRFOm
 v2Y3AauI0fI81+wiNVxMjntx8xQZSTgSssdG7qoNdii10EMFQaaKoFwB2b7o6KU+zwIrIKfZM
 tvq4ltDOqRZcuv6bxlqihYb9VSq+87LegA0nLZP6PrMA5FUIXz4QkjZIQWSjWPmJdFFCXJ3ic
 sBEIeeb4JaqLEK/GiK0TuquZaHfRZj5ILJhJnM9iRMjuN4kYbJ7rKRBwDG6iVvhrQGXWqVv
List-Id: <pgsql-performance.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-performance@lists.postgresql.org>
List-Owner: <mailto:pgsql-performance-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-performance>
Precedence: bulk


--Apple-Mail-81BAAA59-CA2A-45F8-99DB-067B3D9DA137
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

Vacuum everything that you restored

Sent from my iPhone

> On Feb 26, 2020, at 1:19 PM, Michael Lewis <mlewis@entrata.com> wrote:
>=20
> =EF=BB=BF
>> UPDATE multicards
>>    SET defacements =3D COALESCE( count, 0 )
>>   FROM ( SELECT multicard_uid, COUNT(*) AS count FROM tickets GROUP BY mu=
lticard_uid ) AS sub
>>  WHERE uid =3D multicard_uid OR multicard_uid is null;
>=20
> I expect this should work. Not sure of performance of course.

--Apple-Mail-81BAAA59-CA2A-45F8-99DB-067B3D9DA137
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto">Vacuum everything that you restored<br><br>=
<div dir=3D"ltr">Sent from my iPhone</div><div dir=3D"ltr"><br><blockquote t=
ype=3D"cite">On Feb 26, 2020, at 1:19 PM, Michael Lewis &lt;mlewis@entrata.c=
om&gt; wrote:<br><br></blockquote></div><blockquote type=3D"cite"><div dir=3D=
"ltr">=EF=BB=BF<div dir=3D"ltr"><div class=3D"gmail_quote"><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb=
(204,204,204);padding-left:1ex">UPDATE multicards<br>
&nbsp; &nbsp;SET defacements =3D COALESCE( count, 0 )<br>
&nbsp; FROM ( SELECT multicard_uid, COUNT(*) AS count FROM tickets GROUP BY m=
ulticard_uid ) AS sub<br>
&nbsp;WHERE uid =3D multicard_uid OR multicard_uid is null;<br></blockquote>=
<div><br></div><div>I expect this should work. Not sure of performance of co=
urse.<br></div></div></div>
</div></blockquote></body></html>=

--Apple-Mail-81BAAA59-CA2A-45F8-99DB-067B3D9DA137--