MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="=_98d3dd53e298a8f7cc33d5de1b6459c7"
Date: Mon, 12 Aug 2019 19:43:54 -0300
From: =?UTF-8?Q?Lu=C3=ADs_Roberto_Weck?= <luisroberto@siscobra.com.br>
To: Michael Lewis <mlewis@entrata.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re:
Organization: Siscobra Sistemas
In-Reply-To: 
 <CAHOFxGpUwcjhs9trJwAkNNhY8doyi2shzCr=2ymLk+-3RzJhrA@mail.gmail.com>
References: <f2188f91-12ea-cd2b-40b9-eef4a1367252@siscobra.com.br>
 <CAHOFxGqhh5T2Uidw6ha404kiX87ipgs4MCGKOoDOqsp=j4Z89g@mail.gmail.com>
 <3fba6c11d158490b07afebc5a21c7aa9@siscobra.com.br>
 <CAHOFxGpUwcjhs9trJwAkNNhY8doyi2shzCr=2ymLk+-3RzJhrA@mail.gmail.com>
Message-ID: <e3e3f5e059d212c962d8cdb128837549@siscobra.com.br>
User-Agent: Roundcube Webmail/1.3.8
Precedence: bulk

--=_98d3dd53e298a8f7cc33d5de1b6459c7
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

> It seems like it should be-
> 
> SELECT * FROM users u JOIN last_user_event_1 e USING (user_id,user_group); 
> --OR-- 
> SELECT * FROM last_user_event_2 e; 
> 
> for them to produce the same result set, since the last_user_event_2 already (could) have users info in it very simply by select * instead of e.* in that view definition. 
> 
> Are there other important joins/where/order by/limits that would be on this "main query" that is just SELECT * FROM ____ right now which you have dropped to try to simplify the example?

You're right about the queries, I made a mistake. 

Yes, I'm going to filter them by user_id and user_group, possibly (but
not likely) using LIMIT 1. In the explain examples I am using user_id =
1272897 and user_group = 19117
--=_98d3dd53e298a8f7cc33d5de1b6459c7
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html; charset=UTF-8

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html; charset=
=3DUTF-8" /></head><body style=3D'font-size: 10pt; font-family: Verdana,Gen=
eva,sans-serif'>
<blockquote type=3D"cite" style=3D"padding: 0 0.4em; border-left: #1010ff 2=
px solid; margin: 0">
<p>It seems like it should be-</p>
<div>SELECT *&nbsp;FROM users u&nbsp;JOIN last_user_event_1 e USING (user_i=
d,user_group);</div>
<div>--OR--</div>
<div>SELECT *&nbsp;FROM last_user_event_2 e;</div>
<div>&nbsp;</div>
<div>for them to produce the same result set, since the last_user_event_2 a=
lready (could) have users info in it very simply by select * instead of e=
=2E* in that view definition.</div>
<div>&nbsp;</div>
<div>Are there other important joins/where/order by/limits that would be on=
 this "main query" that is just SELECT * FROM ____ right now which you have=
 dropped to try to simplify the example?</div>
</blockquote>
<p>You're right about the queries, I made a mistake.</p>
<p>Yes, I'm going to filter them by user_id and user_group, possibly (but n=
ot likely) using LIMIT 1. In the explain examples I am using user_id =3D&nb=
sp;1272897 and user_group =3D&nbsp;19117</p>
</body></html>

--=_98d3dd53e298a8f7cc33d5de1b6459c7--