Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8AFB59FA0F1 for ; Mon, 29 Oct 2007 08:12:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 51714-04 for ; Mon, 29 Oct 2007 08:11:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from ptb-relay02.plus.net (ptb-relay02.plus.net [212.159.14.213]) by postgresql.org (Postfix) with ESMTP id 0D84A9FA0F0 for ; Mon, 29 Oct 2007 08:11:56 -0300 (ADT) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by ptb-relay02.plus.net with esmtp (Exim) id 1ImSX9-0006u3-KX; Mon, 29 Oct 2007 11:11:51 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id 61C4B274059; Mon, 29 Oct 2007 11:11:51 +0000 (GMT) Message-ID: <4725BFF7.1060303@archonet.com> Date: Mon, 29 Oct 2007 11:11:51 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.6 (X11/20070728) MIME-Version: 1.0 To: Dimitri Fontaine CC: pgsql-performance@postgresql.org, Tom Lane , Sami Dalouche Subject: Re: Outer joins and Seq scans References: <1193606710.9008.12.camel@samlaptop> <1193612147.9809.13.camel@samlaptop> <10339.1193615114@sss.pgh.pa.us> <200710291048.16618.dfontaine@hi-media.com> In-Reply-To: <200710291048.16618.dfontaine@hi-media.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/341 X-Sequence-Number: 27363 Dimitri Fontaine wrote: > Hi, >=20 > Le lundi 29 octobre 2007, Tom Lane a =E9crit : >> Is there any chance you can apply the one-line >> patch shown here: >> http://archives.postgresql.org/pgsql-committers/2007-10/msg00374.php >> >> If rebuilding packages is not to your taste, possibly a down-rev to >> 8.2.4 would be the easiest solution. >=20 > The debian package for PostgreSQL uses a .tar.gz of the upstream code a= long=20 > with a debian/patches/ directory with ordered patches files=20 > (##-whatever.patch). Just adding the given file into this directory bef= ore to=20 > building the package should do.=20 [snip detailed example] It never occurred to me that you could do that. Thanks Dmitri, I learn=20 something here all the time. --=20 Richard Huxton Archonet Ltd