[SQL] Re: [HACKERS] wrong query plan in 7.1beta3

2001-01-27 Thread Tom Lane
Kovacs Zoltan <[EMAIL PROTECTED]> writes: > There seems to be an optimizer problem in 7.1beta3. The query you can see > below worked fast in 7.0.2 but in 7.1beta3 is rather slow. The problem is > that an 'index scan' has been changed to a 'seq scan'. Details: This is fixed in current sources: I g

Re: [HACKERS] wrong query plan in 7.1beta3

2001-01-27 Thread Kovacs Zoltan
On Sat, 27 Jan 2001, Peter Eisentraut wrote: > Kovacs Zoltan writes: > > > There seems to be an optimizer problem in 7.1beta3. The query you can see > > below worked fast in 7.0.2 but in 7.1beta3 is rather slow. The problem is > > that an 'index scan' has been changed to a 'seq scan'. Details: >

Re: [HACKERS] wrong query plan in 7.1beta3

2001-01-27 Thread Peter Eisentraut
Kovacs Zoltan writes: > There seems to be an optimizer problem in 7.1beta3. The query you can see > below worked fast in 7.0.2 but in 7.1beta3 is rather slow. The problem is > that an 'index scan' has been changed to a 'seq scan'. Details: > Subquery Scan sd_user_grant (cost=38.68..38.85 rows=1