Postgres Pro
Downloads
Home   >   mailing lists

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

From Claudio Freire
Subject Re: Performance on large, append-only tables
Date
Msg-id CAGTBQpaTOF-j7L3uVXo64o5vdyzMBHHC4crTWEz_a0wdj0mOcw@mail.gmail.com
Whole thread Raw
In response to Re: Performance on large, append-only tables  (David Yeu <david.yeu@skype.net>)
List pgsql-performance
Tree view 
On Fri, Feb 10, 2012 at 2:00 PM, David Yeu <david.yeu@skype.net> wrote:
>> From your OP:
>>
>>> * Š WHERE group_id = ? ORDER BY created_at DESC LIMIT 20;
>
> Yup, sorry.

Ah, ok, so that should do it.
If you need further improvement, remember to take a look at the deleted stuff.

pgsql-performance by date:

Previous
From: David Yeu
Date:
Subject: Re: Performance on large, append-only tables
Next
From: Josh Berkus
Date:
Subject: Re: random_page_cost = 2.0 on Heroku Postgres