Re: [HACKERS] [BUGS] New hashed IN code ignores distinctiveness of subquery

2003-01-27 Thread Tom Lane
Bradley Baetz <[EMAIL PROTECTED]> writes: > Hmm. OK, I poked through the code a bit more, and I think I now realise > why we were talking across each other. I've attached a 'patch' which > gets the mergejoin counts down to something reasonable. I've just committed a significant set of changes in t

Re: [HACKERS] [BUGS] New hashed IN code ignores distinctiveness of subquery

2003-01-26 Thread Bradley Baetz
[Moving -> -hackers] On Mon, Jan 27, 2003 at 12:00:08AM -0500, Tom Lane wrote: > Bradley Baetz <[EMAIL PROTECTED]> writes: > > However, its much faster (although not as fast as sticking the DISTINCT > > in there myself), but the actual rows coming from the sort is really odd > > - where is that n