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

From Tom Lane
Subject Re: Stats for multi-column indexes
Date
Msg-id 14054.1174404532@sss.pgh.pa.us
Whole thread Raw
In response to Re: Stats for multi-column indexes  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Stats for multi-column indexes  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
Alvaro Herrera <alvherre@commandprompt.com> writes:
> It was also suggested that column pairs in FK relationship could be
> automatically enabled.  So you don't need to specify those manually.

Actually, I think you don't particularly need stats for that in most
cases --- if the planner simply took note that the FK relationship
exists, it would know that each row of the FK side joins to exactly
one row of the PK side, which in typical cases is sufficient.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Stats processor not restarting
Next
From: Andrew Dunstan
Date:
Subject: Re: Buildfarm feature request: some way to track/classify failures