Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 091819FA0DF
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 29 Oct 2007 08:55:44 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 99980-06 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Mon, 29 Oct 2007 08:55:40 -0300 (ADT)
X-Greylist: delayed 00:27:33.462818 by SQLgrey-1.7.5
Received: from pyrrha.dalibo.net (pyrrha.dalibo.net [212.85.154.72])
	by postgresql.org (Postfix) with ESMTP id D25FA9FA07E
	for <pgsql-performance@postgresql.org>;
	Mon, 29 Oct 2007 08:55:39 -0300 (ADT)
Received: from localhost (localhost [127.0.0.1])
	by pyrrha.dalibo.net (Postfix) with ESMTP id 6F5D557806D;
	Mon, 29 Oct 2007 12:28:04 +0100 (CET)
Received: from pyrrha.dalibo.net ([127.0.0.1])
	by localhost (pyrrha.dalibo.net [127.0.0.1]) (amavisd-new, port 10024)
	with ESMTP id igNiaGoICduH; Mon, 29 Oct 2007 12:28:04 +0100 (CET)
Received: by pyrrha.dalibo.net (Postfix, from userid 1011)
	id 4A642578072; Mon, 29 Oct 2007 12:28:04 +0100 (CET)
Received: from [192.168.0.12] (lan31-6-82-238-146-117.fbx.proxad.net
	[82.238.146.117])
	by pyrrha.dalibo.net (Postfix) with ESMTP id 632D157806D;
	Mon, 29 Oct 2007 12:28:02 +0100 (CET)
Message-ID: <4725C3C2.2040304@dalibo.com>
Date: Mon, 29 Oct 2007 12:28:02 +0100
From: =?ISO-8859-1?Q?C=E9dric_Villemain?= <cedric.villemain@dalibo.com>
User-Agent: Mozilla-Thunderbird 2.0.0.4 (X11/20070828)
MIME-Version: 1.0
To: Richard Huxton <dev@archonet.com>
CC: Dimitri Fontaine <dfontaine@hi-media.com>,
	pgsql-performance@postgresql.org, Sami Dalouche <skoobi@free.fr>
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>
	<4725BFF7.1060303@archonet.com>
In-Reply-To: <4725BFF7.1060303@archonet.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200710/343
X-Sequence-Number: 27365

Richard Huxton a écrit :
> Dimitri Fontaine wrote:
>> Hi,
>>
>> Le lundi 29 octobre 2007, Tom Lane a écrit :
>>> 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.
>>
>> The debian package for PostgreSQL uses a .tar.gz of the upstream code 
>> along with a debian/patches/ directory with ordered patches files 
>> (##-whatever.patch). Just adding the given file into this directory 
>> before to building the package should do. 
>
> [snip detailed example]
>
> It never occurred to me that you could do that. Thanks Dmitri, I learn 
> something here all the time.
<more>
You can consider using apt-build(like gentoo users like to do) to patch 
on the fly  (but it does not support tar.gz inside package, wich is 
unfortunely the case for postgresql package ....)
</more>