Re: How to force an Index ?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Rhaoni Chiu Pereira <rhaoni(at)sistemica(dot)info>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to force an Index ?
Date: 2003-08-27 12:24:46
Message-ID: 20030827122446.GC25010@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Aug 26, 2003 at 17:48:38 -0300,
Rhaoni Chiu Pereira <rhaoni(at)sistemica(dot)info> wrote:
> when I need for just one query a especific index to be used the only way is to
> raise the costs ?

There is no way to say to use a specific index. You can turn off some plans
(and raise the cost of sequential scans, since that is sometimes the only
way to do something) or you can adjust the relative costs of such things
as cpu time and disk i/o. Making sure you have done an analyze and that
you have detailed enough statistics for the planner is also important.

P.S. You should keep replies on the list.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Geoff Ellis 2003-08-27 12:37:31 Date Problem on Imports to 7.2.1
Previous Message Hornyak Laszlo 2003-08-27 10:48:42 Re: postgres hab modification without restarting