Re: [PERFORM] Migration study, step 2: rewriting queries

2006-04-18 Thread Tom Lane
"Mikael Carneholm" <[EMAIL PROTECTED]> writes: > Ok, cool. I don't have time to test this right now as the project has to > move on (and I guess testing the fix would require a dump+build CVS > version+restore), but as a temporary workaround I simly dropped the > xda_dat index (all queries on that

Re: [PERFORM] Migration study, step 2: rewriting queries

2006-04-18 Thread Mikael Carneholm
>This should be fixed by the changes I made recently in choose_bitmap_and >--- it wasn't being aggressive about pruning overlapping AND conditions when a sub-OR was involved. It's possible the new coding is >*too* aggressive, and will reject indexes that it'd be profitable to include; but at least

Re: [PERFORM] Migration study, step 2: rewriting queries

2006-04-16 Thread Tom Lane
"Mikael Carneholm" <[EMAIL PROTECTED]> writes: > ..and this last AND seems unnessecary, since the predicate on > (driver_activity_type__id = 5) is included in each of the above > conditions. This should be fixed by the changes I made recently in choose_bitmap_and --- it wasn't being aggressive abo