Re: order by slowing down a query by 80 times

From: Andres Freund <andres(at)anarazel(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Cc: Yeb Havinga <yebhavinga(at)gmail(dot)com>, Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>
Subject: Re: order by slowing down a query by 80 times
Date: 2010-06-28 13:26:34
Message-ID: 201006281526.35156.andres@anarazel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Monday 28 June 2010 13:39:27 Yeb Havinga wrote:
> It looks like seq_scans are disabled, since the index scan has only a
> filter expression but not an index cond.
Or its using it to get an ordered result...

Andres

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2010-06-28 13:41:58 Re: order by slowing down a query by 80 times
Previous Message Yeb Havinga 2010-06-28 11:39:27 Re: order by slowing down a query by 80 times