Top
Enterprise Postgres 16 Release Notes

2.1.9 Changing kernel parameter settings when an instance is created with WebAdmin

Incompatibility

For FUJITSU Enterprise Postgres 13 and later, changes kernel parameter settings for WebAdmin instance creation.

FUJITSU Enterprise Postgres 12 or earlier

Kernel Parameters

Value

Calculated Value

SHMMAX

If currentValue < calculatedValue, configure the calculated value

((1800 + 270 * max_locks_per_transaction) * max_connections +
(1800 + 270 * max_locks_per_transaction) * autovacuum_max_workers + (770 + 270 * max_locks_per_transaction) * max_prepared_transactions + (shared_buffer) + (16 * 1024 * 1024) + ( 770 * 1024)) * 1.05

SHMALL

Specify currentValue + calculatedValue

(SHMMAX / PAGESIZE) + 1
PAGESIZE = 4K

SEMMNI

Specify currentValue + calculatedValue

ceil((max_connections + autovacuum_max_workers + 4) / 16)

SEMMNS

Specify currentValue + calculatedValue

ceil((max_connections + autovacuum_max_workers + 4) / 16) * 17
FUJITSU Enterprise Postgres 13 or later

Kernel Parameters

Value

Calculated Value

SHMMAX

Do not change value

-

SHMALL

Do not change value

-

SEMMNI

Specify currentValue + calculatedValue

  • For instances of FUJITSU Enterprise Postgres 9.5 to 11:

    ceil((max_connections + autovacuum_max_workers + max_worker_processes + 5) / 16)
  • For Fujitsu Enterprise Postgres 12 and later instances:

    ceil((max_connections + autovacuum_max_workers + max_wal_senders +  max_worker_processes + 5) / 16)

SEMMNS

Specify currentValue + calculatedValue

  • For instances of FUJITSU Enterprise Postgres 9.5 to 11:

    ceil((max_connections + autovacuum_max_workers + max_worker_processes + 5) / 16) * 17
  • For Fujitsu Enterprise Postgres 12 and later instances:

    ceil((max_connections + autovacuum_max_workers + max_wal_senders +   max_worker_processes + 5) / 16) * 17

Action method

None.