Postgres Pro
Downloads
Home   >   mailing lists

Re: Cluster vs. non-cluster query planning - Mailing list pgsql-performance

From Tom Lane
Subject Re: Cluster vs. non-cluster query planning
Date
Msg-id 8044.1146515444@sss.pgh.pa.us
Whole thread Raw
In response to Re: Cluster vs. non-cluster query planning  (Nolan Cafferky <Nolan.Cafferky@rbsinteractive.com>)
Responses Re: Cluster vs. non-cluster query planning
List pgsql-performance
Tree view 
Nolan Cafferky <Nolan.Cafferky@rbsinteractive.com> writes:
> After some more digging on the mailing list, I found some comments on
> effective_cache_size.  Bringing it up from the default of 1000 does pust
> the estimated cost for the index scan below that of the sequential scan,
> but not by much.

The first-order knob for tuning indexscan vs seqscan costing is
random_page_cost.  What have you got that set to?

            regards, tom lane

pgsql-performance by date:

Previous
From: Nolan Cafferky
Date:
Subject: Re: Cluster vs. non-cluster query planning
Next
From: Nolan Cafferky
Date:
Subject: Re: Cluster vs. non-cluster query planning