Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT ignoring index even though ORDER BY and LIMIT present - Mailing list pgsql-performance

From Kevin Grittner
Subject Re: SELECT ignoring index even though ORDER BY and LIMIT present
Date
Msg-id 4C0694060200002500031DEA@gw.wicourts.gov
Whole thread Raw
In response to SELECT ignoring index even though ORDER BY and LIMIT present  (Jori Jovanovich <jori@dimensiology.com>)
Responses Re: SELECT ignoring index even though ORDER BY and LIMIT present  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
Tree view 
Jori Jovanovich <jori@dimensiology.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

pgsql-performance by date:

Previous
From: Jori Jovanovich
Date:
Subject: SELECT ignoring index even though ORDER BY and LIMIT present
Next
From: Szymon Guz
Date:
Subject: Re: SELECT ignoring index even though ORDER BY and LIMIT present