Re: [HACKERS] [GENERAL] Estimated rows question

2012-09-12 Thread David Fetter
On Wed, Sep 12, 2012 at 07:19:06PM -0400, Tom Lane wrote: > Sam Ross writes: > > On Sat, Sep 1, 2012 at 8:47 PM, Tom Lane 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,

Re: [HACKERS] [GENERAL] Estimated rows question

2012-09-12 Thread Tom Lane
Sam Ross writes: > On Sat, Sep 1, 2012 at 8:47 PM, Tom Lane 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

Re: [HACKERS] [GENERAL] Estimated rows question

2012-09-12 Thread Sam Ross
On Sat, Sep 1, 2012 at 8:47 PM, Tom Lane wrote: > [ sorry for slow response, but I'd not gotten time to think about this... ] > > Sam Ross writes: >> I was wondering why it seems that the query planner can't "see", based >> on the histograms, that two join-columns have a very small >> intersectio