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

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Jori Jovanovich" <jori(at)dimensiology(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: SELECT ignoring index even though ORDER BY and LIMIT present
Date: 2010-06-02 22:25:26
Message-ID: 4C0694060200002500031DEA@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Jori Jovanovich <jori(at)dimensiology(dot)com> wrote:

> what is the recommended way to solve this?

The recommended way is to adjust your costing configuration to
better reflect your environment. What version of PostgreSQL is
this? What do you have set in your postgresql.conf file? What does
the hardware look like? How big is the active (frequently
referenced) portion of your database?

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Szymon Guz 2010-06-02 22:27:47 Re: SELECT ignoring index even though ORDER BY and LIMIT present
Previous Message Mark Kirkwood 2010-06-02 22:13:29 Re: File system choice for Red Hat systems