Re: Cross column statistics - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Cross column statistics
Date
Msg-id 42088BC3.8040907@familyhealth.com.au
Whole thread Raw
In response to Cross column statistics  (Greg Stark <gsstark@mit.edu>)
Responses Re: Cross column statistics
List pgsql-hackers
> B) gather a full matrix of the level of "correlation" between each column and
>    each other column. If this were a single floating point number per pair
>    then it might be feasible. It would still obviously be n^2 in the number of
>    columns though, so there would have to be some way to limit on how many
>    columns would be analyzed this way.

Use foreign keys to just record those cross-correlations.

Chris


pgsql-hackers by date:

Previous
From: Christopher Kings-Lynne
Date:
Subject: AT TIME ZONE
Next
From: "Magnus Hagander"
Date:
Subject: Re: AT TIME ZONE