Re: Migration study, step 2: rewriting queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



>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 it won't make this particular mistake.

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 table include the
person_information__id column anyway).

- Mikael




[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux