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
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
Hello,
I have a simple table which has a cube column and a cube GiST index. The
column contains 3-dimensional points (not cubes or intervals). The
problem is that I'm getting very slow queries when I'm using the index.
The table has about 130,000 rows and is full-vacuumed after any
updates/i
