Skip site navigation (1) Skip section navigation (2)

Stats for multi-column indexes

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Stats for multi-column indexes
Date: 2007-03-20 00:56:00
Message-ID: 1174352160.23455.453.camel@dogma.v10.wvs (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
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).

	Jeff Davis


pgsql-hackers by date

Next:From: Tom LaneDate: 2007-03-20 01:11:57
Subject: buildfarm not reporting xml flag correctly?
Previous:From: Tom LaneDate: 2007-03-20 00:51:47
Subject: Re: [COMMITTERS] pgsql: Changes pg_trigger and extend pg_rewrite in order to allow

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group