Re: Cross column statistics

From: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Cross column statistics
Date: 2005-02-08 09:52:03
Message-ID: 42088BC3.8040907@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Magnus Hagander 2005-02-08 11:37:07 Re: AT TIME ZONE
Previous Message Christopher Kings-Lynne 2005-02-08 09:46:04 AT TIME ZONE