Re: [BUGS] BUG #5542: Query optimization problem

2010-07-08 Thread Robert Haas
On Tue, Jul 6, 2010 at 2:43 AM, Roman wrote: > I have a query: > > SELECT d1.ID, d2.ID > FROM DocPrimary d1 >  JOIN DocPrimary d2 ON d2.BasedOn=d1.ID > WHERE (d1.ID=234409763) or (d2.ID=234409763) > > i think what QO(Query Optimizer) can make it faster (now it seq scan and on > million records wor

Re: [BUGS] BUG #5542: Query optimization problem

2010-07-06 Thread Craig Ringer
On 06/07/10 14:43, Roman wrote: > > The following bug has been logged online: > > Bug reference: 5542 > Logged by: Roman > Email address: zo...@oe-it.ru > PostgreSQL version: 9.0 > Operating system: Win7 x64 > Description:Query optimization problem > Details: On the