Re: [BUGS] Terrible perfomance during nested "... where x in (select ...)" operator

2001-05-11 Thread Stephan Szabo
Known issue, see FAQ item 4.23. Short form, use exists rather than in. On Tue, 8 May 2001, [KOI8-R] þÅÒÅÐÁÎÏ× ìÅÏÎÉÄ wrote: > Leonid ([EMAIL PROTECTED]) reports a bug with a severity of 2(?) > > Short Description > Terrible perfomance during nested "... where x in (select ...)" operator > >

[BUGS] Terrible perfomance during nested "... where x in (select ...)" operator

2001-05-11 Thread Черепанов Леонид
Leonid ([EMAIL PROTECTED]) reports a bug with a severity of 2(?) Short Description Terrible perfomance during nested "... where x in (select ...)" operator Long Description PostgreSQL 7.1, FreeBSD 4.2-STABLE Analyzing the reasons for terrible perfomance of my query I've found a very strange thi