Re: [GENERAL] Some mystery with execution plans on postgres 8.1

2006-06-07 Thread Tom Lane
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, ev

Re: [GENERAL] Some mystery with execution plans on postgres 8.1

2006-06-07 Thread Tom Lane
Boguk Maxim <[EMAIL PROTECTED]> writes: > If short: adding index to table change execution plans on query which dont > use new index. Exactly which PG version is this? regards, tom lane ---(end of broadcast)--- TIP 3: Have y