Breadstick Get it on Google Play

postgresql-17-pg-hint-plan

support for optimizer hints in PostgreSQL

UnsupportedCommand lineDevelopment

Unsupported

The PostgreSQL server, and the extensions that run inside it, needs a System V shared memory segment even when set to use mmap, and Android refuses it (initdb fails on a device, with and without Breadstick's shared-memory library).

Programs that need System V shared memory

PlatformStandardVM
Android, ARM64UnsupportedUntested
GooglebookOS, ARM64UnsupportedUntested
GooglebookOS, x86-64UnsupportedUntested
ChromeOS, ARM64UnsupportedUntested
ChromeOS, x86-64UnsupportedUntested

About postgresql-17-pg-hint-plan

From Debian's package description

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) */.

From Debian's description of the postgresql-17-pg-hint-plan package, under that package's license.

Dependencies

Depends on

Sources and licenses

  • Name: the Debian package name.
  • Summary: Debian's short description of the postgresql-17-pg-hint-plan package, under that package's license.
  • Description: Debian's description of the postgresql-17-pg-hint-plan package, under that package's license.
  • Versions and sizes: Debian's archive for ARM64, as on packages.debian.org.
  • Popularity: Debian Popularity Contest counts.

More in About the catalog.