Re: An Idea for planner hints - Mailing list pgsql-hackers

From Joshua Reich
Subject Re: An Idea for planner hints
Date
Msg-id 44DA3881.4020201@root.net
Whole thread Raw
In response to Re: An Idea for planner hints  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: An Idea for planner hints
List pgsql-hackers
> (Not sure how we'd implement that, seeing that ANALYZE currently works
> on one table at a time, but it's probably doable --- and it'd fix the
> fundamental problem for correlation statistics, which is how not to try
> to collect stats about an exponential number of combinations ...)


An exponential number of combinations? Is it possible to use FK 
relationships to determine what tables & columns are likely to be used 
in future joins.

Josh



pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: An Idea for planner hints
Next
From: "Dave Page"
Date:
Subject: Re: 8.2 features status