Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

Next:From: bricklenDate: 2009-09-10 16:56:36
Subject: Re: Sub-optimal plan chosen
Previous:From: tvDate: 2009-09-10 15:40:24
Subject: Re: Sub-optimal plan chosen

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group