Re: Efficiently query for the most recent record for a given user

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Efficiently query for the most recent record for a given user
Дата
Msg-id 9813.1375900452@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Efficiently query for the most recent record for a given user  (Claudio Freire <klaussfreire@gmail.com>)
Ответы Re: Efficiently query for the most recent record for a given user  (Claudio Freire <klaussfreire@gmail.com>)
Список pgsql-performance
Claudio Freire <klaussfreire@gmail.com> writes:
> On Wed, Aug 7, 2013 at 3:12 PM, Robert DiFalco <robert.difalco@gmail.com> wrote:
>> I want to get the last call_activity record for a single user.

> Create an index over (user_id, called desc), and do
> select * from call_activity where user_id = blarg order by called desc limit 1

Note that there's no particular need to specify "desc" in the index
definition.  This same index can support searches in either direction
on the "called" column.

            regards, tom lane


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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: Efficiently query for the most recent record for a given user
Следующее
От: Igor Neyman
Дата:
Сообщение: Re: Efficiently query for the most recent record for a given user