Re: Performance on large, append-only tables

From: Claudio Freire <klaussfreire(at)gmail(dot)com>
To: David Yeu <david(dot)yeu(at)skype(dot)net>
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 17:12:11
Message-ID: CAGTBQpaTOF-j7L3uVXo64o5vdyzMBHHC4crTWEz_a0wdj0mOcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Fri, Feb 10, 2012 at 2:00 PM, David Yeu <david(dot)yeu(at)skype(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2012-02-10 19:32:50 Re: random_page_cost = 2.0 on Heroku Postgres
Previous Message David Yeu 2012-02-10 17:00:50 Re: Performance on large, append-only tables