Re: SELECT ignoring index even though ORDER BY and LIMIT present

From: Szymon Guz <mabewlun(at)gmail(dot)com>
To: Jori Jovanovich <jori(at)dimensiology(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: SELECT ignoring index even though ORDER BY and LIMIT present
Date: 2010-06-02 22:27:47
Message-ID: AANLkTik_WsMVgYzPjH_C0vjq9XqW-73SlmNnGKVPKVkR@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2010/6/2 Jori Jovanovich <jori(at)dimensiology(dot)com>

> hi,
>
> I have a problem space where the main goal is to search backward in time
> for events. Time can go back very far into the past, and so the
> table can get quite large. However, the vast majority of queries are all
> satisfied by relatively recent data. I have an index on the row creation
> date and I would like almost all of my queries to have a query plan looking
> something like:
>
>
>
[CUT]

Do you have autovacuum running? Have you tried updating statistics?

regards
Szymon Guz

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2010-06-02 22:41:52 Re: SELECT ignoring index even though ORDER BY and LIMIT present
Previous Message Kevin Grittner 2010-06-02 22:25:26 Re: SELECT ignoring index even though ORDER BY and LIMIT present