Re: Performance on large, append-only tables - Mailing list pgsql-performance

From David Yeu
Subject Re: Performance on large, append-only tables
Date
Msg-id 79A88D19-AF27-4598-B616-51B6D130A9F0@skype.net
Whole thread Raw
In response to Re: Performance on large, append-only tables  (Claudio Freire <klaussfreire@gmail.com>)
Responses Re: Performance on large, append-only tables  (Claudio Freire <klaussfreire@gmail.com>)
List 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 by date:

Previous
From: Claudio Freire
Date:
Subject: Re: Performance on large, append-only tables
Next
From: Claudio Freire
Date:
Subject: Re: Performance on large, append-only tables