Re: Outer joins and Seq scans

From: Cédric Villemain <cedric(dot)villemain(at)dalibo(dot)com>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, pgsql-performance(at)postgresql(dot)org, Sami Dalouche <skoobi(at)free(dot)fr>
Subject: Re: Outer joins and Seq scans
Date: 2007-10-29 11:28:02
Message-ID: 4725C3C2.2040304@dalibo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2007-10-29 11:40:05 Re: Append Cost in query planners
Previous Message Richard Huxton 2007-10-29 11:11:51 Re: Outer joins and Seq scans