Re: Disabling nested loops - worst case performance - Mailing list pgsql-performance

From Claudio Freire
Subject Re: Disabling nested loops - worst case performance
Date
Msg-id AANLkTikdXec-hR4hAo5kVyQyrdt-qKRqhYYCmLBxT-A1@mail.gmail.com
Whole thread Raw
In response to Disabling nested loops - worst case performance  (Anssi Kääriäinen <anssi.kaariainen@thl.fi>)
List pgsql-performance
On Fri, Mar 18, 2011 at 7:52 AM, Vitalii Tymchyshyn <tivv00@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.

pgsql-performance by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Fastest pq_restore?
Next
From: tv@fuzzy.cz
Date:
Subject: Re: Help with Query Tuning