firtst release
修訂 | fce09b4501bae0b686170904d00480b327a6220d (tree) |
---|---|
時間 | 2016-01-15 12:24:26 |
作者 | Kyotaro Horiguchi <horiguchi.kyotaro@lab....> |
Commiter | Kyotaro Horiguchi |
Prepare for 1.1.3/PG95.
The pg_hint_plan version of master branch is left as 1.1.2. This
commit corrects the pg_hint_plan version, and edits RPM building
environment for PostgreSQL 9.5.
@@ -1,11 +1,11 @@ | ||
1 | 1 | # |
2 | 2 | # pg_hint_plan: Makefile |
3 | 3 | # |
4 | -# Copyright (c) 2012-2014, NIPPON TELEGRAPH AND TELEPHONE CORPORATION | |
4 | +# Copyright (c) 2012-2015, NIPPON TELEGRAPH AND TELEPHONE CORPORATION | |
5 | 5 | # |
6 | 6 | |
7 | 7 | MODULES = pg_hint_plan |
8 | -HINTPLANVER = 1.1.2 | |
8 | +HINTPLANVER = 1.1.3 | |
9 | 9 | |
10 | 10 | REGRESS = init base_plan pg_hint_plan ut-init ut-A ut-S ut-J ut-L ut-G ut-R ut-fdw ut-fini |
11 | 11 |
@@ -14,7 +14,7 @@ REGRESSION_EXPECTED = expected/init.out expected/base_plan.out expected/pg_hint_ | ||
14 | 14 | REGRESS_OPTS = --encoding=UTF8 |
15 | 15 | |
16 | 16 | EXTENSION = pg_hint_plan |
17 | -DATA = pg_hint_plan--1.1.2.sql | |
17 | +DATA = pg_hint_plan--1.1.3.sql | |
18 | 18 | |
19 | 19 | EXTRA_CLEAN = sql/ut-fdw.sql expected/ut-fdw.out |
20 | 20 |
@@ -23,8 +23,8 @@ PGXS := $(shell $(PG_CONFIG) --pgxs) | ||
23 | 23 | include $(PGXS) |
24 | 24 | |
25 | 25 | STARBALL = pg_dbms_stats-$(DBMSSTATSVER).tar.gz |
26 | -STARBALL94 = pg_hint_plan94-$(HINTPLANVER).tar.gz | |
27 | -STARBALLS = $(STARBALL) $(STARBALL94) | |
26 | +STARBALL95 = pg_hint_plan95-$(HINTPLANVER).tar.gz | |
27 | +STARBALLS = $(STARBALL) $(STARBALL95) | |
28 | 28 | |
29 | 29 | TARSOURCES = Makefile *.c *.h \ |
30 | 30 | pg_hint_plan--*.sql \ |
@@ -34,7 +34,7 @@ TARSOURCES = Makefile *.c *.h \ | ||
34 | 34 | |
35 | 35 | installcheck: $(REGRESSION_EXPECTED) |
36 | 36 | |
37 | -rpms: rpm94 | |
37 | +rpms: rpm95 | |
38 | 38 | |
39 | 39 | # pg_hint_plan.c includes core.c and make_join_rel.c |
40 | 40 | pg_hint_plan.o: core.c make_join_rel.c # pg_stat_statements.c |
@@ -49,7 +49,7 @@ $(STARBALLS): $(TARSOURCES) | ||
49 | 49 | tar -chzf $@ $(addprefix $(subst .tar.gz,,$@)/, $^) |
50 | 50 | rm $(subst .tar.gz,,$@) |
51 | 51 | |
52 | -rpm94: $(STARBALL94) | |
53 | - MAKE_ROOT=`pwd` rpmbuild -bb SPECS/pg_hint_plan94.spec | |
52 | +rpm95: $(STARBALL95) | |
53 | + MAKE_ROOT=`pwd` rpmbuild -bb SPECS/pg_hint_plan95.spec | |
54 | 54 | |
55 | 55 |
@@ -1,84 +0,0 @@ | ||
1 | -# SPEC file for pg_hint_plan | |
2 | -# Copyright(C) 2012-2014 NIPPON TELEGRAPH AND TELEPHONE CORPORATION | |
3 | - | |
4 | -%define _pgdir /usr/pgsql-9.4 | |
5 | -%define _bindir %{_pgdir}/bin | |
6 | -%define _libdir %{_pgdir}/lib | |
7 | -%define _datadir %{_pgdir}/share | |
8 | -%if "%(echo ${MAKE_ROOT})" != "" | |
9 | - %define _rpmdir %(echo ${MAKE_ROOT})/RPMS | |
10 | - %define _sourcedir %(echo ${MAKE_ROOT}) | |
11 | -%endif | |
12 | - | |
13 | -## Set general information for pg_hint_plan. | |
14 | -Summary: Optimizer hint for PostgreSQL 9.4 | |
15 | -Name: pg_hint_plan94 | |
16 | -Version: 1.1.2 | |
17 | -Release: 1%{?dist} | |
18 | -License: BSD | |
19 | -Group: Applications/Databases | |
20 | -Source0: %{name}-%{version}.tar.gz | |
21 | -#URL: http://example.com/pg_hint_plan/ | |
22 | -BuildRoot: %{_tmppath}/%{name}-%{version}-%{release}-%(%{__id_u} -n) | |
23 | -Vendor: NIPPON TELEGRAPH AND TELEPHONE CORPORATION | |
24 | - | |
25 | -## We use postgresql-devel package | |
26 | -BuildRequires: postgresql94-devel | |
27 | -Requires: postgresql94-libs | |
28 | - | |
29 | -## Description for "pg_hint_plan" | |
30 | -%description | |
31 | -pg_hint_plan provides capability to force arbitrary plan to PostgreSQL' planner | |
32 | -to optimize queries by hand directly. | |
33 | - | |
34 | -If you have query plan better than which PostgreSQL chooses, you can force your | |
35 | -plan by adding special comment block with optimizer hint before the query you | |
36 | -want to optimize. You can control scan method, join method, join order, and | |
37 | -planner-related GUC parameters during planning. | |
38 | - | |
39 | -Note that this package is available for only PostgreSQL 9.4. | |
40 | - | |
41 | -## pre work for build pg_hint_plan | |
42 | -%prep | |
43 | -PATH=/usr/pgsql-9.4/bin:$PATH | |
44 | -if [ "${MAKE_ROOT}" != "" ]; then | |
45 | - pushd ${MAKE_ROOT} | |
46 | - make clean %{name}-%{version}.tar.gz | |
47 | - popd | |
48 | -fi | |
49 | -if [ ! -d %{_rpmdir} ]; then mkdir -p %{_rpmdir}; fi | |
50 | -%setup -q | |
51 | - | |
52 | -## Set variables for build environment | |
53 | -%build | |
54 | -PATH=/usr/pgsql-9.4/bin:$PATH | |
55 | -make USE_PGXS=1 %{?_smp_mflags} | |
56 | - | |
57 | -## Set variables for install | |
58 | -%install | |
59 | -rm -rf %{buildroot} | |
60 | -install -d %{buildroot}%{_libdir} | |
61 | -install pg_hint_plan.so %{buildroot}%{_libdir}/pg_hint_plan.so | |
62 | -install -d %{buildroot}%{_datadir}/extension | |
63 | -install -m 644 pg_hint_plan--1.1.2.sql %{buildroot}%{_datadir}/extension/pg_hint_plan--1.1.2.sql | |
64 | -install -m 644 pg_hint_plan.control %{buildroot}%{_datadir}/extension/pg_hint_plan.control | |
65 | - | |
66 | -%clean | |
67 | -rm -rf %{buildroot} | |
68 | - | |
69 | -%files | |
70 | -%defattr(0755,root,root) | |
71 | -%{_libdir}/pg_hint_plan.so | |
72 | -%defattr(0644,root,root) | |
73 | -%{_datadir}/extension/pg_hint_plan--1.1.2.sql | |
74 | -%{_datadir}/extension/pg_hint_plan.control | |
75 | - | |
76 | -# History of pg_hint_plan. | |
77 | -%changelog | |
78 | -* Thu Dec 17 2014 Kyotaro Horiguchi | |
79 | -- Support 9.4. New rev 1.1.2. | |
80 | -* Mon Sep 02 2013 Takashi Suzuki | |
81 | -- Initial cut for 1.1.0 | |
82 | -* Mon Sep 24 2012 Shigeru Hanada <shigeru.hanada@gmail.com> | |
83 | -- Initial cut for 1.0.0 | |
84 | - |
@@ -1,4 +1,4 @@ | ||
1 | -/* pg_hint_plan/pg_hint_plan--1.1.2.sql */ | |
1 | +/* pg_hint_plan/pg_hint_plan--1.1.3.sql */ | |
2 | 2 | |
3 | 3 | -- complain if script is sourced in psql, rather than via CREATE EXTENSION |
4 | 4 | \echo Use "CREATE EXTENSION pg_hint_plan" to load this file. \quit |
@@ -1,6 +1,6 @@ | ||
1 | 1 | # pg_hint_plan extension |
2 | 2 | |
3 | 3 | comment = '' |
4 | -default_version = '1.1.2' | |
4 | +default_version = '1.1.3' | |
5 | 5 | relocatable = false |
6 | 6 | schema = hint_plan |