Sam Ross <elliptic@gmail.com> writes:
> On Sat, Sep 1, 2012 at 8:47 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Do you want to try it and submit a patch for testing?
> Thanks for the answer, and sorry for the slow reply -
> I'm not sure I have the necessary expertise, but I'll be happy to give
> it a shot. Is there an already-assembled library of queries that is
> used to test purported improvements to the planner, or is it expected
> that I come up with a convincing test-set myself?
No, we don't really have much in that line :-(. There's the regression
tests of course, but they're mostly about functionality not quality of
statistical estimates. In practice, as long as a proposed change made
the estimates demonstrably better in some reasonable scenarios, and
didn't slow it down very much, that would probably be enough.
regards, tom lane