1 # SPEC file for pg_dbms_stats13
2 # Copyright(C) 2012-2020 NIPPON TELEGRAPH AND TELEPHONE CORPORATION
4 %define _pgdir /usr/pgsql-13
5 %define _bindir %{_pgdir}/bin
6 %define _libdir %{_pgdir}/lib
7 %define _datadir %{_pgdir}/share
8 %define _docdir %{_datadir}/doc
9 %define _bcdir %{_libdir}/bitcode
11 %if "%(echo ${MAKE_ROOT})" != ""
12 %define _rpmdir %(echo ${MAKE_ROOT})/RPMS
13 %define _sourcedir %(echo ${MAKE_ROOT})
16 ## Set general information for pg_dbms_stats.
17 Summary: Plan Stabilizer for PostgreSQL 13
22 Group: Applications/Databases
23 Source: %{name}-%{version}.tar.gz
24 URL: https://osdn.net/projects/pgdbmsstats/
25 BuildRoot: %{buildroot}
26 Vendor: NIPPON TELEGRAPH AND TELEPHONE CORPORATION
28 ## postgresql-devel package required
29 #BuildRequires: postgresql13-devel
30 #Requires: postgresql13-server
32 ## Description for "pg_dbms_stats"
34 pg_dbms_stats disguises database statistics with a prevously taken
35 snapshot so that the planner won't change its behavior even after
36 ANALYZE updates the statistics.
38 pg_dbms_stats also provides following features:
39 - backup multiple generations of planner statistics to reuse plans afterwards
40 - import planner statistics from another system for tuning or testing.
42 Note that this package is available for only PostgreSQL 13.
45 Requires: postgresql13-server, postgresql13-llvmjit
46 Requires: pg_hint_plan13 = 1.5.0b1
47 Summary: Just-in-time compilation support for pg_hint_plan11
50 Just-in-time compilation support for pg_hint_plan11
52 ## pre work for build pg_dbms_stats
54 PATH=/usr/pgsql-13/bin:$PATH
55 if [ ! -d %{_rpmdir} ]; then mkdir -p %{_rpmdir}; fi
58 ## Set variables for build environment
60 PATH=/usr/pgsql-13/bin:$PATH
61 make USE_PGXS=1 %{?_smp_mflags}
63 ## Set variables for install
66 make install DESTDIR=%{buildroot}
72 %defattr(0755,root,root)
73 %{_libdir}/pg_dbms_stats.so
74 %defattr(0644,root,root)
75 %{_datadir}/extension/pg_dbms_stats--%{version}.sql
76 %{_datadir}/extension/pg_dbms_stats.control
77 %{_docdir}/extension/export_effective_stats-13.sql.sample
78 %{_docdir}/extension/export_plain_stats-13.sql.sample
83 # History of pg_dbms_stats.
85 * Thu Aug 6 2020 Kyotaro Horiguchi
86 - Update to 1.5.0b1. Support PG13.
87 * Thu Aug 6 2020 Kyotaro Horiguchi
88 - Update to 1.4.0. Support PG12.
89 * Wed Sep 26 2018 Kyotaro Horiguchi
90 - Update to 1.3.11. Bug fix.
91 * Thu Apr 05 2018 Kyotaro Horiguchi
92 - Update to 1.3.10. Bug fix.
93 * Mon Nov 13 2017 Kyotaro Horiguchi
94 - Update to 1.3.9. Bug fixed.
95 * Tue Oct 10 2017 Kyotaro Horiguchi
96 - pg_dbms_stats10 v1.3.8 release