Re: Outer joins and Seq scans

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Outer joins and Seq scans
Дата
Msg-id 200710291048.16618.dfontaine@hi-media.com
обсуждение исходный текст
Ответ на Re: Outer joins and Seq scans  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Outer joins and Seq scans  (Richard Huxton <dev@archonet.com>)
Список 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

Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Outer joins and Seq scans
Следующее
От: "Nimesh Satam"
Дата:
Сообщение: Re: Append Cost in query planners