On Fri, Mar 18, 2011 at 7:52 AM, Vitalii Tymchyshyn <tivv00(at)gmail(dot)com> wrote:
> 18.03.11 09:15, Anssi Kääriäinen написав(ла):
> Hello.
>
> If your queries work on single attribute, you can try adding partial indexes
> for different attributes. Note that in this case parameterized statements
> may prevent index usage, so check also with attribute id inlined.
And if your queries work on a single entity instead, you can partition
the table per-entity thus "teach" the database enging about the
correlation.