Re: new correlation metric - Mailing list pgsql-hackers

From Ron Mayer
Subject Re: new correlation metric
Date
Msg-id 4905FC1B.7030202@cheapcomplexdevices.com
Whole thread Raw
In response to Re: new correlation metric  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: new correlation metric
List pgsql-hackers
Tom Lane wrote:
> Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
>> ...bitmap cost estimates didn't also change much....
> 
> By definition, a bitmap scan's cost isn't affected by index order
> correlation.

No?   I think I understand that for index scans the correlation
influenced how many data pages are estimated to get sucked in.

Wouldn't a bitmap scan using a single index also fetch roughly
the same number of data pages as an index scan?

I'm not complaining, since 8.3's doing great on all my real-world
queries.   And sorry for my naive questions - feel free to tell
me to just read the code if this is something I should be able
to figure out myself.



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Hot Standby utility and administrator functions
Next
From: Jeff Davis
Date:
Subject: Re: array_agg and array_accum (patch)