Re: Query optimizer 8.0.1 (and 8.0) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Query optimizer 8.0.1 (and 8.0)
Date
Msg-id 5307.1107713442@sss.pgh.pa.us
Whole thread Raw
In response to Re: Query optimizer 8.0.1 (and 8.0)  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
List pgsql-hackers
Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> What I think I'd like to see is for there to be
> another statistic similar to "correlation" but rather
> than looking at the total-ordering of the table, to
> look how correlated values within any single page are.

Our current approach to correlation is surely far too simplistic; it was
just a quick hack to get *something* in there for this consideration.
I don't personally know enough about statistics to do much better :-(
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Failed assertion on cluster
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Patch Count?