Re:

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Luís Roberto Weck <luisroberto(at)siscobra(dot)com(dot)br>
Cc: pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re:
Date: 2019-08-12 22:53:41
Message-ID: CAHOFxGqT2CQHmP8J_qE3nwLL-3xMSFjjr1cpmTY4Wv4ioEqRVg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

If you modify last_user_event_2 to select user and event info in the view,
and just put there where clause directly on the view which is not joined to
anything, instead of on the "extra copy" of the users table like you were
showing previously, I would expect that the performance should be excellent.

>

In response to

  • Re: at 2019-08-12 22:43:54 from Luís Roberto Weck

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Luís Roberto Weck 2019-08-12 23:03:54 Re: Last event per user
Previous Message Luís Roberto Weck 2019-08-12 22:43:54 Re: