From: Dimitri Fontaine <dfontaine@hi-media.com>
To: pgsql-performance@postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Sami Dalouche <skoobi@free.fr>
Subject: Re: Outer joins and Seq scans
Date: Mon, 29 Oct 2007 10:48:14 +0100
Message-ID: <200710291048.16618.dfontaine@hi-media.com> (raw)
In-Reply-To: <10339.1193615114@sss.pgh.pa.us>
References: <1193606710.9008.12.camel@samlaptop>
<1193612147.9809.13.camel@samlaptop>
<10339.1193615114@sss.pgh.pa.us>
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
Attachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: dfontaine@hi-media.com, tgl@sss.pgh.pa.us, skoobi@free.fr
Subject: Re: Outer joins and Seq scans
In-Reply-To: <200710291048.16618.dfontaine@hi-media.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox