Received: from maia.hub.org (maia-5.hub.org [200.46.204.29])
	by mail.postgresql.org (Postfix) with ESMTP id 891CD6329C7
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 28 Jun 2010 10:26:46 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024)
	with ESMTP id 74858-09
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Mon, 28 Jun 2010 13:26:39 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail.anarazel.de (mail.anarazel.de [217.115.131.40])
	by mail.postgresql.org (Postfix) with ESMTP id 9FBB86329BB
	for <pgsql-performance@postgresql.org>;
	Mon, 28 Jun 2010 10:26:39 -0300 (ADT)
Received: from alap2.localnet (p579FAC7E.dip.t-dialin.net [87.159.172.126])
	by mail.anarazel.de (Postfix) with ESMTPSA id 956AA448006;
	Mon, 28 Jun 2010 15:26:36 +0200 (CEST)
From: Andres Freund <andres@anarazel.de>
To: pgsql-performance@postgresql.org
Subject: Re: order by slowing down a query by 80 times
Date: Mon, 28 Jun 2010 15:26:34 +0200
User-Agent: KMail/1.13.3 (Linux/2.6.35-rc3-andres-00128-gbf29376; KDE/4.4.85;
	x86_64; ; )
Cc: Yeb Havinga <yebhavinga@gmail.com>,
	Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
References: <AANLkTim6WXLK8iJuwZbzJjCuPr9LPau1OX7vxwYDFdkN@mail.gmail.com>
	<4C2889EF.1050908@gmail.com>
In-Reply-To: <4C2889EF.1050908@gmail.com>
MIME-Version: 1.0
Content-Type: Text/Plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Message-Id: <201006281526.35156.andres@anarazel.de>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.79 tagged_above=-10 required=5 tests=BAYES_50=0.8,
	T_RP_MATCHES_RCVD=-0.01
X-Spam-Level: 
X-Archive-Number: 201006/498
X-Sequence-Number: 39354

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