pg-hint-plan-17_1.7.0-1_amd64.changes (click to toggle) | |
---|---|
Format: | 1.8 |
Date: | Fri, 13 Sep 2024 18:18:55 +0200 |
Source: | pg-hint-plan-17 |
Binary: | postgresql-17-pg-hint-plan postgresql-17-pg-hint-plan-dbgsym |
Architecture: | source amd64 |
Version: | 1.7.0-1 |
Distribution: | unstable |
Urgency: | medium |
Maintainer: | Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org> |
Changed-By: | Christoph Berg <myon@debian.org> |
Description: | postgresql-17-pg-hint-plan - support for optimizer hints in PostgreSQL |
Changes: | pg-hint-plan-17 (1.7.0-1) unstable; urgency=medium * pg-hint-plan for PostgreSQL 17. * Restrict to 64-bit architectures. * Mark postgresql-all as <!nocheck>. |
Files: | ec99df7abd9371bb9a4106d6616e3439 2173 database optional pg-hint-plan-17_1.7.0-1.dsc 3c4bd3c5f3c80d231a25b73ab53e8954 211992 database optional pg-hint-plan-17_1.7.0.orig.tar.gz 9e5675fea46d9fd1f7ed62d430a3b460 3320 database optional pg-hint-plan-17_1.7.0-1.debian.tar.xz 4ef3b37864764da851a5afb22f7afaa5 11753 database optional pg-hint-plan-17_1.7.0-1_amd64.buildinfo d81d0418331efacde094f1b7a57efa90 137872 debug optional postgresql-17-pg-hint-plan-dbgsym_1.7.0-1_amd64.deb df6dbe2343ccc2da2703556d3c7a2dc0 145400 database optional postgresql-17-pg-hint-plan_1.7.0-1_amd64.deb |
pg-hint-plan-17_1.7.0-1.dsc (click to toggle) | |
---|---|
Format: | 3.0 (quilt) |
Source: | pg-hint-plan-17 |
Binary: | postgresql-17-pg-hint-plan |
Architecture: | any |
Version: | 1.7.0-1 |
Maintainer: | Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org> |
Uploaders: | Christoph Berg <myon@debian.org>, |
Homepage: | https://github.com/ossc-db/pg_hint_plan |
Standards-Version: | 4.7.0 |
Vcs-Browser: | https://salsa.debian.org/postgresql/pg-hint-plan |
Vcs-Git: | https://salsa.debian.org/postgresql/pg-hint-plan.git -b 17 |
Testsuite: | autopkgtest |
Testsuite-Triggers: | make |
Build-Depends: | architecture-is-64-bit<!pkg.postgresql.32-bit>, debhelper-compat (=13), flex, postgresql-all<!nocheck>, postgresql-server-dev-all |
Package-List: | postgresql-17-pg-hint-plan deb database optional arch=any |
Files: | 3c4bd3c5f3c80d231a25b73ab53e8954 211992 pg-hint-plan-17_1.7.0.orig.tar.gz 9e5675fea46d9fd1f7ed62d430a3b460 3320 pg-hint-plan-17_1.7.0-1.debian.tar.xz |
control file for postgresql-17-pg-hint-plan_1.7.0-1_amd64.deb (click to toggle) | |
---|---|
Package: | postgresql-17-pg-hint-plan |
Source: | pg-hint-plan-17 |
Version: | 1.7.0-1 |
Architecture: | amd64 |
Maintainer: | Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org> |
Installed-Size: | 321 |
Depends: | postgresql-17, postgresql-17-jit-llvm (>=16), libc6 (>=2.14) |
Section: | database |
Priority: | optional |
Homepage: | https://github.com/ossc-db/pg_hint_plan |
Description: | support for optimizer hints in PostgreSQL PostgreSQL uses a cost-based optimizer that uses data statistics, not static rules. The planner (optimizer) estimates costs of each possible execution plans for a SQL statement, then executes the plan with the lowest cost. The planner does its best to select the best execution plan, but it is far from perfect, since it may not count some data properties, like correlation between columns. . pg_hint_plan makes it possible to tweak PostgreSQL execution plans using so-called "hints" in SQL comments, like /*+ SeqScan(a) */. |
contents of postgresql-17-pg-hint-plan_1.7.0-1_amd64.deb (click to toggle) | |
---|---|
drwxr-xr-x root/root 0 2024-09-13 16:18 ./ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/lib/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/lib/postgresql/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/lib/postgresql/17/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/lib/postgresql/17/lib/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/lib/postgresql/17/lib/bitcode/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/lib/postgresql/17/lib/bitcode/pg_hint_plan/ -rw-r--r-- root/root 114784 2024-09-13 16:18 ./usr/lib/postgresql/17/lib/bitcode/pg_hint_plan/pg_hint_plan.bc -rw-r--r-- root/root 37328 2024-09-13 16:18 ./usr/lib/postgresql/17/lib/bitcode/pg_hint_plan/query_scan.bc -rw-r--r-- root/root 13212 2024-09-13 16:18 ./usr/lib/postgresql/17/lib/bitcode/pg_hint_plan.index.bc -rw-r--r-- root/root 96184 2024-09-13 16:18 ./usr/lib/postgresql/17/lib/pg_hint_plan.so drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/share/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/share/doc/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/share/doc/postgresql-17-pg-hint-plan/ -rw-r--r-- root/root 2836 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/README -rw-r--r-- root/root 292 2024-09-13 16:18 ./usr/share/doc/postgresql-17-pg-hint-plan/changelog.Debian.gz -rw-r--r-- root/root 3004 2024-09-13 16:18 ./usr/share/doc/postgresql-17-pg-hint-plan/copyright -rw-r--r-- root/root 1240 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/description.md -rw-r--r-- root/root 892 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/errors.md -rw-r--r-- root/root 987 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/functional_limitations.md -rw-r--r-- root/root 2874 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/hint_details.md.gz -rw-r--r-- root/root 3470 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/hint_list.md -rw-r--r-- root/root 2823 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/hint_table.md.gz -rw-r--r-- root/root 240 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/index.md -rw-r--r-- root/root 1340 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/installation.md -rw-r--r-- root/root 483 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/requirements.md -rw-r--r-- root/root 567 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/synopsis.md -rw-r--r-- root/root 288 2024-08-26 05:25 ./usr/share/doc/postgresql-17-pg-hint-plan/uninstallation.md drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/share/postgresql/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/share/postgresql/17/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/share/postgresql/17/extension/ -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.0--1.3.1.sql -rw-r--r-- root/root 684 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.0.sql -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.1--1.3.2.sql -rw-r--r-- root/root 433 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.10--1.4.sql -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.2--1.3.3.sql -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.3--1.3.4.sql -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.4--1.3.5.sql -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.5--1.3.6.sql -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.6--1.3.7.sql -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.7--1.3.8.sql -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.8--1.3.9.sql -rw-r--r-- root/root 438 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.3.9--1.3.10.sql -rw-r--r-- root/root 434 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.4--1.4.1.sql -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.4.1--1.4.2.sql -rw-r--r-- root/root 436 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.4.2--1.4.3.sql -rw-r--r-- root/root 433 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.4.3--1.5.sql -rw-r--r-- root/root 435 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.5--1.5.1.sql -rw-r--r-- root/root 437 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.5.1--1.5.2.sql -rw-r--r-- root/root 437 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.5.2--1.6.0.sql -rw-r--r-- root/root 439 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.6.0--1.6.1.sql -rw-r--r-- root/root 850 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan--1.6.1--1.7.0.sql -rw-r--r-- root/root 134 2024-09-13 16:18 ./usr/share/postgresql/17/extension/pg_hint_plan.control |
copyright of postgresql-17-pg-hint-plan_1.7.0-1_amd64.deb (click to toggle) | |
---|---|
Format: https://www.debian.org/doc/packaging-manuals/copyright-format/1.0/ Upstream-Name: pg-hint-plan Source: https://github.com/ossc-db/pg_hint_plan Files: * Copyright: Copyright (c) 2012-2023, NIPPON TELEGRAPH AND TELEPHONE CORPORATION License: NTT All rights reserved. . Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: . * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. * Neither the name of the NIPPON TELEGRAPH AND TELEPHONE CORPORATION (NTT) nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission. . THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. Files: core.c make_join_rel.c query_scan.l Copyright: Portions Copyright (c) 1996-2024, PostgreSQL Global Development Group Portions Copyright (c) 1994, The Regents of the University of California License: PostgreSQL Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies. . IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. . THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. |
control file for postgresql-17-pg-hint-plan-dbgsym_1.7.0-1_amd64.deb (click to toggle) | |
---|---|
Package: | postgresql-17-pg-hint-plan-dbgsym |
Source: | pg-hint-plan-17 |
Version: | 1.7.0-1 |
Auto-Built-Package: | debug-symbols |
Architecture: | amd64 |
Maintainer: | Debian PostgreSQL Maintainers <team+postgresql@tracker.debian.org> |
Installed-Size: | 159 |
Depends: | postgresql-17-pg-hint-plan (=1.7.0-1) |
Section: | debug |
Priority: | optional |
Description: | debug symbols for postgresql-17-pg-hint-plan |
Build-Ids: | 491b3d39867fd57f40a687362ae1286078d2bd08 |
contents of postgresql-17-pg-hint-plan-dbgsym_1.7.0-1_amd64.deb (click to toggle) | |
---|---|
drwxr-xr-x root/root 0 2024-09-13 16:18 ./ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/lib/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/lib/debug/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/lib/debug/.build-id/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/lib/debug/.build-id/49/ -rw-r--r-- root/root 151840 2024-09-13 16:18 ./usr/lib/debug/.build-id/49/1b3d39867fd57f40a687362ae1286078d2bd08.debug drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/share/ drwxr-xr-x root/root 0 2024-09-13 16:18 ./usr/share/doc/ lrwxrwxrwx root/root 0 2024-09-13 16:18 ./usr/share/doc/postgresql-17-pg-hint-plan-dbgsym -> postgresql-17-pg-hint-plan |
copyright of postgresql-17-pg-hint-plan-dbgsym_1.7.0-1_amd64.deb (click to toggle) | |
---|---|
WARNING: No copyright found, please check package manually. |
Timestamp: 13.09.2024 / 17:02:17 (UTC)