I wonder how the performance of your partial index would compare to a pgsql materialized view implementation? [0] Did you by chance explore such an option?
[0]: http://www.pgcon.org/2008/schedule/attachments/63_BSDCan2008...
[0]: http://www.pgcon.org/2008/schedule/attachments/63_BSDCan2008...
I think you are adding another entity that you must now support and that the application must specifically call.
If your application supports multiple databases, i don't think you want to have specific code to support optimization. Of course you need to do this :)