Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group