Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 39575B5DBD0 for ; Mon, 10 Oct 2011 05:04:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 70893-06 for ; Mon, 10 Oct 2011 08:04:39 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2 Received: from nm10-vm0.bullet.mail.ird.yahoo.com (nm10-vm0.bullet.mail.ird.yahoo.com [77.238.189.90]) by mail.postgresql.org (Postfix) with SMTP id 33509B5DBCA for ; Mon, 10 Oct 2011 05:04:38 -0300 (ADT) Received: from [77.238.189.52] by nm10.bullet.mail.ird.yahoo.com with NNFMP; 10 Oct 2011 08:04:38 -0000 Received: from [212.82.108.125] by tm5.bullet.mail.ird.yahoo.com with NNFMP; 10 Oct 2011 08:04:38 -0000 Received: from [127.0.0.1] by omp1034.mail.ird.yahoo.com with NNFMP; 10 Oct 2011 08:04:38 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 236853.76172.bm@omp1034.mail.ird.yahoo.com Received: (qmail 17367 invoked by uid 60001); 10 Oct 2011 08:04:38 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.it; s=s1024; t=1318233877; bh=ZMTdv7+MFTXp28XKlNj6lCT0KvJEGvJ93fLVuD90idk=; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=tDVLuljfis4AFBZPuM/sXguR6woZxVEWGUlHIJO/wJZFBWzaKGNTuLwhupLUT0ZtbK29ucHmk7xUKXRXWRDNoC9rNT4P0WuaVzmIhOyk3MGu1K+gETfGHE038lx49ddA390+1sQE/bQtSsvGD/Oe/gCbwe9O1GSEGHobScK8/oE= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.it; h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=jV/bV3jTfxEB7O+YZo6DhI0Z45JAwYF7UQp75ALyh8dG7OJrAlILAxCLOacEYHoBBkjP6YIwVXFdOm7ECJ4mUIw6bSEp+sTHJlg5w0LffC+ApJIS+++cZqOD6NoYpRiFhDbyhL2RfTS2MjTUyjeJ2XZPMKmESRRnamwpAUz68Xg=; X-YMail-OSG: dzIe8oYVM1kUpdw1J5URMC.4KG7RdNU3.ln8etSVMEIP_Oa VZpedwmgtJOm7qaclr5YaTHmKj2f8HfU3Jfoh6v5Lh38E.7a0E62mnh9oLKz myexca4wsH1Qj98tto90tpyAqoLTuLddzx3EyMmdB6Vta8WDvu95DePiAwUN UktYHvaleAGwJv5hBYBhy4PZeucgVkphgbbOEzEvQjhZs59RpcBP5.3nsLec pf91KG03goP0VFNfYJg5Rlz9pnhwpg978FPJNBglJ62pX_VOUsbsDrK2ZpfI zJwQkfncPqg0ymcWX2FMOV9rD1Cxboc4oSEdzdygPqpfv9VMEJNkijZhVHkC AonkGjdRWuz_HLxJ1maiuxk5yWJfHoeRyJlYmxfReW_LF83_xdyAH9aeA56w E2LU- Received: from [85.33.62.89] by web29020.mail.ird.yahoo.com via HTTP; Mon, 10 Oct 2011 09:04:37 BST X-Mailer: YahooMailWebService/0.8.114.317681 References: <4E79E091.2030401@peak6.com> <4E79A6FF0200002500041506@gw.wicourts.gov> <4E7A259F.9060401@2ndQuadrant.com> <23412.1317838554@sss.pgh.pa.us> Message-ID: <1318233877.13796.YahooMailNeo@web29020.mail.ird.yahoo.com> Date: Mon, 10 Oct 2011 09:04:37 +0100 (BST) From: Leonardo Francalanci Reply-To: Leonardo Francalanci Subject: Re: : Performance Improvement Strategy To: Scott Marlowe Cc: "pgsql-performance@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201110/76 X-Sequence-Number: 45298 >> =A0 =A0 =A0 =A0* Allow CLUSTER to sort the table rather than scanning t= he index=A0=0A=0A> when it seems likely to be cheaper (Leonardo Francalanci= )=0A> =0A> Looks like I owe Leonardo Francalanci a pizza.=0A=0A=0A=0AWell, = the patch started from a work by=A0Gregory Stark, and Tom fixed=0Aa nasty b= ug; but I'll take a slice ;)=0A=0A=0ALeonardo=0A