Re:

Michael Lewis <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance
Message-ID <CAHOFxGqT2CQHmP8J_qE3nwLL-3xMSFjjr1cpmTY4Wv4ioEqRVg@mail.gmail.com>
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.

>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.