Re: Last event per user

Поиск
Список
Период
Сортировка
От Michael Lewis
Тема Re: Last event per user
Дата
Msg-id CAHOFxGpUwcjhs9trJwAkNNhY8doyi2shzCr=2ymLk+-3RzJhrA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Last event per user  (Luís Roberto Weck <luisroberto@siscobra.com.br>)
Ответы Re:  (Luís Roberto Weck <luisroberto@siscobra.com.br>)
Список pgsql-performance
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?

В списке pgsql-performance по дате отправления:

Предыдущее
От: Luís Roberto Weck
Дата:
Сообщение: Re: Last event per user
Следующее
От: Michael Lewis
Дата:
Сообщение: Re: Planner performance in partitions