Re: cpu_tuple_cost - Mailing list pgsql-performance

From Tom Lane
Subject Re: cpu_tuple_cost
Date
Msg-id 5580.1110781746@sss.pgh.pa.us
Whole thread Raw
In response to cpu_tuple_cost  (Daniel Schuchardt <daniel_schuchardt@web.de>)
Responses Re: cpu_tuple_cost  ("Greg Sabino Mullane" <greg@turnstep.com>)
Re: cpu_tuple_cost  (Daniel Schuchardt <daniel_schuchardt@web.de>)
List pgsql-performance
Daniel Schuchardt <daniel_schuchardt@web.de> writes:
> i have a query plan who is bad with standard cpu_tuple_costs and good if
> I raise cpu_tuple_costs. Is it is a good practice to raise them if i
> want to force postgres to use indexes more often?

Reducing random_page_cost is usually the best way to get the planner to
favor indexscans more.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] How to read query plan
Next
From: Gourish Singbal
Date:
Subject: column name is "LIMIT"