On Fri, Mar 18, 2011 at 7:52 AM, Vitalii Tymchyshyn <tivv00@xxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
