From: | Robert Klemme <shortcutter(at)googlemail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Advice on optimizing select/index |
Date: | 2013-05-26 12:34:10 |
Message-ID: | knsvg4$ldg$1@ger.gmane.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
On 22.05.2013 16:37, Niels Kristian Schjødt wrote:
> In reality the adverts that are selected is all 'active'. I'm hence
> wondering if it theoretically (and in reality of cause) would make my
> query faster if I did something like: "SELECT .* FROM cars LEFT
> OUTER JOIN adverts on cars.id = adverts.car_id WHERE cars.brand =
> 'Audi' AND adverts.state = 'active'" with a partial index on "INDEX
> adverts ON (car_id) WHERE state = 'active'"?
That sounds reasonable to do. If you have enough bandwidth on your
production database why not just try it out? Otherwise you could do
this on a test database and see how it goes and what plan you get. Btw.
did you look at the original plan?
Cheers
robert
From | Date | Subject | |
---|---|---|---|
Next Message | John Mudd | 2013-05-27 14:02:26 | Slow SELECT by primary key? Postgres 9.1.2 |
Previous Message | Tomas Vondra | 2013-05-25 21:00:19 | Re: Reporting query failing |