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

From Dimitri Fontaine
Subject Re: Outer joins and Seq scans
Date
Msg-id 200710291048.16618.dfontaine@hi-media.com
Whole thread Raw
In response to Re: Outer joins and Seq scans  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Outer joins and Seq scans
List 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

Attachment

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: Outer joins and Seq scans
Next
From: "Nimesh Satam"
Date:
Subject: Re: Append Cost in query planners