pg_control_init()

A system function exposing a subset of pg_control data about the cluster initialization state

pg_control_init() is a system function exposing a subset of pg_control data about the cluster initialization state.

pg_control_init() was added in PostgreSQL 9.6 (commit dc7d70ea).

Examples

postgres=# SELECT * FROM pg_control_init();
-[ RECORD 1 ]--------------+---------
max_data_alignment         | 8
database_block_size        | 8192
blocks_per_segment         | 131072
wal_block_size             | 8192
bytes_per_wal_segment      | 16777216
max_identifier_length      | 64
max_index_columns          | 32
max_toast_chunk_size       | 1996
large_object_chunk_size    | 2048
float4_pass_by_value       | t
float8_pass_by_value       | t
data_page_checksum_version | 1

Categories

PostgreSQL internals, System function

See also

pg_controldata, pg_control_system(), pg_control_checkpoint(), pg_control_recovery()