Re: proposal : cross-column stats - Mailing list pgsql-hackers

From Tomas Vondra
Subject Re: proposal : cross-column stats
Date
Msg-id 4D066D1C.7000405@fuzzy.cz
Whole thread Raw
In response to Re: proposal : cross-column stats  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: proposal : cross-column stats  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: proposal : cross-column stats
Next
From: David Fetter
Date:
Subject: Re: CommitFest wrap-up