Re: Stats for multi-column indexes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Stats for multi-column indexes
Date
Msg-id 16545.1174418355@sss.pgh.pa.us
Whole thread Raw
In response to Re: Stats for multi-column indexes  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-hackers
"Jim C. Nasby" <jim@nasby.net> writes:
> It might be worth coming up with a different means to store the
> histogram for the multi-column case.

A separate array for each column involved seems a whole lot less
fragile than pretending we can handle mixed-type arrays.

We probably need a different catalog anyway, or at least a reimagining
of pg_statistic, since it doesn't hold more than one value of staattnum
per row.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Buildfarm feature request: some way to track/classify failures
Next
From: Tom Lane
Date:
Subject: Re: Money type todos?