On Fri, Mar 18, 2011 at 7:52 AM, Vitalii Tymchyshyn <tiv...@gmail.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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance