Re: Outer joins and Seq scans - Mailing list pgsql-performance

From Cédric Villemain
Subject Re: Outer joins and Seq scans
Date
Msg-id 4725C3C2.2040304@dalibo.com
Whole thread Raw
In response to Re: Outer joins and Seq scans  (Richard Huxton <dev@archonet.com>)
List pgsql-performance
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>

pgsql-performance by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Append Cost in query planners
Next
From: "Nimesh Satam"
Date:
Subject: Re: Append Cost in query planners