Dima Tkach <dmitry(at)openratings(dot)com> writes:
> But, one problem was that in 7.2 partial indexes do not really work
> (more precisely, do not get used) if your query has more than one table
> (Tom has given me a patch to fix that a while back, but I never got to
> installing it) :-(
That patch is in 7.2.2 and later. If you're still running 7.2 or 7.2.1
I have *zero* sympathy for any problems you may have. Update before
you get bit by one of the data-loss bugs we've fixed.
regards, tom lane