it looks like it might choose wrong plan, cos it gets the stats wrong. Try increasing number of stats to 100. Btw, what version it is ?
- [PERFORM] Optimizing Bitmap Heap Scan. niraj patel
- Re: [PERFORM] Optimizing Bitmap Heap Scan. Grzegorz Jaśkiewicz
- Re: [PERFORM] Optimizing Bitmap Heap Scan. niraj patel
- Re: [PERFORM] Optimizing Bitmap Heap Sca... Lennin Caro
- Re: [PERFORM] Optimizing Bitmap Heap... Kevin Grittner
- Re: [PERFORM] Optimizing Bitmap Heap... Robert Haas
- Re: [PERFORM] Optimizing Bitmap Heap Scan. Matthew Wakeling
- Re: [PERFORM] Optimizing Bitmap Heap Scan. niraj patel
- Re: [PERFORM] Optimizing Bitmap Heap Sca... Matthew Wakeling