Re: Sub-optimal plan chosen

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: bricklen <bricklen(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Sub-optimal plan chosen
Date: 2009-09-10 15:43:11
Message-ID: 24520.1252597391@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

bricklen <bricklen(at)gmail(dot)com> writes:
> Is there any other data I can provide to shed some light on this?

The table and index definitions?

The straight indexscan would probably win if the index column order
were ofid, date instead of date, ofid. I can't tell if you have
any other queries for which the existing column order is preferable,
though.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message bricklen 2009-09-10 16:56:36 Re: Sub-optimal plan chosen
Previous Message tv 2009-09-10 15:40:24 Re: Sub-optimal plan chosen