From: Dimitri Fontaine <dfontaine@hi-media.com>
Organization: Hi-Media
To: pgsql-performance@postgresql.org
Subject: Re: Outer joins and Seq scans
Date: Mon, 29 Oct 2007 10:48:14 +0100
User-Agent: KMail/1.9.7
Cc: Tom Lane <tgl@sss.pgh.pa.us>,
 Sami Dalouche <skoobi@free.fr>
References: <1193606710.9008.12.camel@samlaptop>
	<1193612147.9809.13.camel@samlaptop>
	<10339.1193615114@sss.pgh.pa.us>
In-Reply-To: <10339.1193615114@sss.pgh.pa.us>
MIME-Version: 1.0
Content-Type: multipart/signed; boundary="nextPart1792381.3jjsWfkkqG";
	protocol="application/pgp-signature"; micalg=pgp-sha1
Content-Transfer-Encoding: 7bit
Message-Id: <200710291048.16618.dfontaine@hi-media.com>

--nextPart1792381.3jjsWfkkqG
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

Hi,

Le lundi 29 octobre 2007, Tom Lane a =C3=A9crit=C2=A0:
> 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=
=20
with a debian/patches/ directory with ordered patches files=20
(##-whatever.patch). Just adding the given file into this directory before =
to=20
building the package should do.=20

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=20
 $ 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 t=
he=20
version number to your taste by editing debian/changelog and adding (for=20
example) a postgresql-8.2 (8.2.5.1-1) entry, just before the debuild step.

Hope this helps,
=2D-=20
dim

--nextPart1792381.3jjsWfkkqG
Content-Type: application/pgp-signature; name=signature.asc 
Content-Description: This is a digitally signed message part.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQBHJaxglBXRlnbh1bkRAi++AJ9uJlLc0KXJ6VcWeTQ1k4xNe/vO8ACcDBm7
T+UR2AOoJMirtNohix9OqNI=
=S3oW
-----END PGP SIGNATURE-----

--nextPart1792381.3jjsWfkkqG--