|From:||Jeff Davis <pgsql(at)j-davis(dot)com>|
|Subject:||Stats for multi-column indexes|
|Views:||Raw Message | Whole Thread | Download mbox | Resend email|
I know the idea has come up a few times to do cross-column statistics to
improve plans when the data distributions are dependent. I found a
couple references in the archives:
We can already keep stats for a functional index. Is there a reason we
can't keep stats for a multi-column index?
Out of the two situations outlined by Jim Nasby here:
It would not help with joins, but it would help with columns that are
referred to as a group (e.g. a=1 AND b<20).
|Next Message||Tom Lane||2007-03-20 01:11:57||buildfarm not reporting xml flag correctly?|
|Previous Message||Tom Lane||2007-03-20 00:51:47||Re: [COMMITTERS] pgsql: Changes pg_trigger and extend pg_rewrite in order to allow|