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

Re: Outer joins and Seq scans

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Sami Dalouche <skoobi(at)free(dot)fr>
Subject: Re: Outer joins and Seq scans
Date: 2007-10-29 09:48:14
Message-ID: 200710291048.16618.dfontaine@hi-media.com (view raw or flat)
Thread:
Lists: pgsql-performance
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. 

The operations to issue should look like this:
 $ apt-get source postgresql-8.2
 $ tar xzf postgresql-8.2_8.2.5.orig.tar.gz
 $ cd postgresql-8.2-8.2.5 
 $ zcat ../postgresql-8.2_8.2.5-1.diff.gz |patch -p1
 $ cp make_outerjoininfo.patch debian/patches/60-make_outerjoininfo.patch
 $ debuild -us -uc

This will give you a new package for postgresql, which you can even tweak the 
version number to your taste by editing debian/changelog and adding (for 
example) a postgresql-8.2 (8.2.5.1-1) entry, just before the debuild step.

Hope this helps,
-- 
dim

In response to

Responses

pgsql-performance by date

Next:From: Nimesh SatamDate: 2007-10-29 11:09:16
Subject: Re: Append Cost in query planners
Previous:From: Tom LaneDate: 2007-10-28 23:45:14
Subject: Re: Outer joins and Seq scans

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