Re: Performance on large, append-only tables

From: David Yeu <david(dot)yeu(at)skype(dot)net>
To: Claudio Freire <klaussfreire(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance on large, append-only tables
Date: 2012-02-10 16:45:39
Message-ID: 79A88D19-AF27-4598-B616-51B6D130A9F0@skype.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 that seems to obviate the need for any index on created_at.

Dave

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Claudio Freire 2012-02-10 16:58:13 Re: Performance on large, append-only tables
Previous Message Claudio Freire 2012-02-10 16:26:54 Re: Performance on large, append-only tables