Re: Performance on large, append-only tables

Поиск
Список
Период
Сортировка
От David Yeu
Тема Re: Performance on large, append-only tables
Дата
Msg-id 79A88D19-AF27-4598-B616-51B6D130A9F0@skype.net
обсуждение исходный текст
Ответ на Re: Performance on large, append-only tables  (Claudio Freire <klaussfreire@gmail.com>)
Ответы Re: Performance on large, append-only tables  (Claudio Freire <klaussfreire@gmail.com>)
Список pgsql-performance
On Feb 10, 2012, at 11:26 AM, Claudio Freire wrote:
> That, and an index on "(group_id, created_at) where (deleted_at IS
> NULL)" to catch the sorted by date kind of query, and you'll be done I
> think.

Yeah, I didn't quite get that right -- we're actually sorting all these queries by "id DESC", not "created_at DESC", so
thatseems to obviate the need for any index on created_at.  

Dave




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

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: Performance on large, append-only tables
Следующее
От: Claudio Freire
Дата:
Сообщение: Re: Performance on large, append-only tables