Re: [GENERAL] Query performs badly with materialize node

2011-09-23 Thread Alban Hertroys
On 23 September 2011 12:31, Ingmar Brouns wrote: > > > > In short: if you want to get useful commentary on your problem, you > > need to provide a more complete picture. > > > >regards, tom lane > > > > I've posted the query plans now several times to this list, but they >

Re: [GENERAL] Query performs badly with materialize node

2011-09-23 Thread Ingmar Brouns
> > In short: if you want to get useful commentary on your problem, you > need to provide a more complete picture. > >                        regards, tom lane > I've posted the query plans now several times to this list, but they do not show up, almost as if being caught by a spam filter or somet

Re: [GENERAL] Query performs badly with materialize node

2011-09-19 Thread Tom Lane
Ingmar Brouns writes: > What I find strange is that there is a conditionless index scan on > participates, retrieving all its rows, and then a nested loop over all those > rows and a materialize node. Yeah, that indexscan looks pretty odd to me too, but it's likely explained by the context that y