Re: proposal : cross-column stats

Dne 13.12.2010 16:38, Tom Lane napsal(a):
> The reason that this wasn't done years ago is precisely that nobody's
> figured out how to do it with a tolerable amount of stats data and a
> tolerable amount of processing time (both at ANALYZE time and during
> query planning).  It's not hard to see what we'd ideally like to do;
> it's getting from there to something useful in production that's hard.

OK, I fully realize that. My plan is to simply

  (a) find out what statistics do we need to collect and how to use it
  (b) implement a really stupid inefficient solution
  (c) optimize in iterations, i.e. making it faster, consuming less
      space etc.

It will take time, it won't be perfect for a long time, but every
journey starts somewhere.

regards
Tomas