Re: [PERFORM] Slow query using the Cube contrib module.

2010-07-27 Thread Tom Lane
Yeb Havinga writes: > Liviu Mirea-Ghiban wrote: >> My question is: Why is it doing a Bitmap Heap Scan / Recheck Cond? >> I've executed dozens of such queries and not once did the rechecking >> remove any rows. Is there any way to disable it, or do you have any >> other suggestions for optimizat

Re: [PERFORM] Slow query using the Cube contrib module.

2010-07-27 Thread Yeb Havinga
Liviu Mirea-Ghiban wrote: My question is: Why is it doing a Bitmap Heap Scan / Recheck Cond? I've executed dozens of such queries and not once did the rechecking remove any rows. Is there any way to disable it, or do you have any other suggestions for optimizations (because I'm all out of ide