Boguk Maxim <[EMAIL PROTECTED]> writes: > If short: adding index to table change execution plans on query which dont > use new index.
After some experimentation I was able to create a similar misbehavior here. I think what is happening is that the added index is capturing the bitmap scan plan, even though it ends up making that plan more expensive and thus a loser to the plain indexscan. The reason is this bug: http://archives.postgresql.org/pgsql-committers/2006-06/msg00064.php which makes choose_bitmap_and sort the available indexes in the wrong order. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match