Configuration
10 minute read
The parameters listed in the table represent the specific configuration settings that we customize from the default configuration provided by PostgreSQL. These parameters are tailored to suit our platform’s requirements and are carefully selected to optimize performance and reliability.
Note: Parameters marked with an asterisk (*) are dynamically calculated based on available compute resources, allowing for seamless vertical scaling.
You can change the parameters listed in the table yourself in Cloudhub.
| Parameter | Type | Default | Modifiable | Restart Required | Min | Max | Allowed Values |
|---|---|---|---|---|---|---|---|
| default_statistics_target | integer | 100 | True | False | 50 | 500 | |
| effective_cache_size* | string | 4GB | True | False | |||
| effective_io_concurrency | integer | 200 | True | False | 1 | 1000 | |
| jit | string | on | True | True | on off | ||
| maintenance_work_mem* | string | 64MB | True | False | |||
| max_connections* | integer | 100 | True | True | 1 | 262143 | |
| max_locks_per_transaction | integer | 64 | True | True | 10 | 2147483647 | |
| max_parallel_maintenance_workers* | integer | 2 | True | False | |||
| max_parallel_workers* | integer | 8 | True | False | |||
| max_parallel_workers_per_gather* | integer | 2 | True | False | |||
| max_wal_size | string | 1GB | True | True | |||
| max_worker_processes* | integer | 8 | True | True | |||
| min_wal_size | string | 80MB | True | True | |||
| random_page_cost | string | 1.1 | True | False | |||
| shared_buffers* | string | 128MB | True | True | |||
| shared_preload_libraries | string | (empty) | True | True | pg_stat_statements | ||
| shm_size | string | 64M | True | True | |||
| ssl_min_protocol_version | string | TLSv1.2 | True | True | TLSv1 TLSv1.1 TLSv1.2 TLSv1.3 | ||
| temp_file_limit | integer | -1 | True | False | |||
| timezone | string | Europe/Berlin | True | True | |||
| wal_buffers | integer | -1 | True | True | |||
| work_mem* | string | 4MB | True | False |
Column Explanation
- Parameter: This column lists the configuration parameters.
- Type: Indicates the data type of the configuration parameter (e.g., integer, string).
- Default: Displays the default value for each parameter.
- Modifiable: Indicates whether the parameter can be modified (
true/false). - Restart Required: Specifies whether a server restart is required for changes to take effect (
true/false). - Min: Shows the minimum permissible value for numeric parameters.
- Max: Displays the maximum permissible value for numeric parameters.
- Allowed Values: Lists the values allowed for string parameters.
Available PostgreSQL Extension PostgreSQL 14
| Name | Version | Comment | Activation |
|---|---|---|---|
| btree_gin | 1.3 | support for indexing common datatypes in GIN | Self-service |
| btree_gist | 1.7 | support for indexing common datatypes in GiST | Self-service |
| citext | 1.6 | data type for case-insensitive character strings | Self-service |
| cube | 1.5 | data type for multidimensional cubes | Self-service |
| dict_int | 1.0 | text search dictionary template for integers | Self-service |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings | Self-service |
| hstore | 1.8 | data type for storing sets of (key, value) pairs | Self-service |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers | Self-service |
| isn | 1.2 | data types for international product numbering standards | Self-service |
| lo | 1.1 | Large Object maintenance | Self-service |
| ltree | 1.3 | data type for hierarchical tree-like structures | Self-service |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams | Self-service |
| pgcrypto | 1.3 | cryptographic functions | Self-service |
| seg | 1.4 | data type for representing line segments or floating-point intervals | Self-service |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | Self-service |
| tcn | 1.0 | Triggered change notifications | Self-service |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | Self-service |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | Self-service |
| unaccent | 1.1 | text search dictionary that removes accents | Self-service |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | Self-service |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | Via ticket |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | Via ticket |
| orafce | 4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | Via ticket |
| pgaudit | 17.1 | provides auditing functionality | Via ticket |
| pljava | 1.6.10 | PL/Java procedural language | Via ticket |
| postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions | Via ticket |
| postgis_raster | 3.6.4 | PostGIS raster types and functions | Via ticket |
| postgis_sfcgal | 3.6.4 | PostGIS SFCGAL functions | Via ticket |
| postgis_tiger_geocoder | 3.6.4 | PostGIS tiger geocoder and reverse geocoder | Via ticket |
| postgis_topology | 3.6.4 | PostGIS topology spatial types and functions | Via ticket |
| vector | 0.8.7 | vector data type and ivfflat and hnsw access methods | Via ticket |
Available PostgreSQL Extension PostgreSQL 15
| Name | Version | Comment | Activation |
|---|---|---|---|
| btree_gin | 1.3 | support for indexing common datatypes in GIN | Self-service |
| btree_gist | 1.7 | support for indexing common datatypes in GiST | Self-service |
| citext | 1.6 | data type for case-insensitive character strings | Self-service |
| cube | 1.5 | data type for multidimensional cubes | Self-service |
| dict_int | 1.0 | text search dictionary template for integers | Self-service |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings | Self-service |
| hstore | 1.8 | data type for storing sets of (key, value) pairs | Self-service |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers | Self-service |
| isn | 1.2 | data types for international product numbering standards | Self-service |
| lo | 1.1 | Large Object maintenance | Self-service |
| ltree | 1.3 | data type for hierarchical tree-like structures | Self-service |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams | Self-service |
| pgcrypto | 1.3 | cryptographic functions | Self-service |
| seg | 1.4 | data type for representing line segments or floating-point intervals | Self-service |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | Self-service |
| tcn | 1.0 | Triggered change notifications | Self-service |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | Self-service |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | Self-service |
| unaccent | 1.1 | text search dictionary that removes accents | Self-service |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | Self-service |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | Via ticket |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | Via ticket |
| orafce | 4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | Via ticket |
| pgaudit | 17.1 | provides auditing functionality | Via ticket |
| pljava | 1.6.10 | PL/Java procedural language | Via ticket |
| postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions | Via ticket |
| postgis_raster | 3.6.4 | PostGIS raster types and functions | Via ticket |
| postgis_sfcgal | 3.6.4 | PostGIS SFCGAL functions | Via ticket |
| postgis_tiger_geocoder | 3.6.4 | PostGIS tiger geocoder and reverse geocoder | Via ticket |
| postgis_topology | 3.6.4 | PostGIS topology spatial types and functions | Via ticket |
| vector | 0.8.7 | vector data type and ivfflat and hnsw access methods | Via ticket |
Available PostgreSQL Extension PostgreSQL 16
| Name | Version | Comment | Activation |
|---|---|---|---|
| btree_gin | 1.3 | support for indexing common datatypes in GIN | Self-service |
| btree_gist | 1.7 | support for indexing common datatypes in GiST | Self-service |
| citext | 1.6 | data type for case-insensitive character strings | Self-service |
| cube | 1.5 | data type for multidimensional cubes | Self-service |
| dict_int | 1.0 | text search dictionary template for integers | Self-service |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings | Self-service |
| hstore | 1.8 | data type for storing sets of (key, value) pairs | Self-service |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers | Self-service |
| isn | 1.2 | data types for international product numbering standards | Self-service |
| lo | 1.1 | Large Object maintenance | Self-service |
| ltree | 1.3 | data type for hierarchical tree-like structures | Self-service |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams | Self-service |
| pgcrypto | 1.3 | cryptographic functions | Self-service |
| seg | 1.4 | data type for representing line segments or floating-point intervals | Self-service |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | Self-service |
| tcn | 1.0 | Triggered change notifications | Self-service |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | Self-service |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | Self-service |
| unaccent | 1.1 | text search dictionary that removes accents | Self-service |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | Self-service |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | Via ticket |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | Via ticket |
| orafce | 4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | Via ticket |
| pgaudit | 17.1 | provides auditing functionality | Via ticket |
| pljava | 1.6.10 | PL/Java procedural language | Via ticket |
| postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions | Via ticket |
| postgis_raster | 3.6.4 | PostGIS raster types and functions | Via ticket |
| postgis_sfcgal | 3.6.4 | PostGIS SFCGAL functions | Via ticket |
| postgis_tiger_geocoder | 3.6.4 | PostGIS tiger geocoder and reverse geocoder | Via ticket |
| postgis_topology | 3.6.4 | PostGIS topology spatial types and functions | Via ticket |
| vector | 0.8.7 | vector data type and ivfflat and hnsw access methods | Via ticket |
Available PostgreSQL Extension PostgreSQL 17
| Name | Version | Comment | Activation |
|---|---|---|---|
| btree_gin | 1.3 | support for indexing common datatypes in GIN | Self-service |
| btree_gist | 1.7 | support for indexing common datatypes in GiST | Self-service |
| citext | 1.6 | data type for case-insensitive character strings | Self-service |
| cube | 1.5 | data type for multidimensional cubes | Self-service |
| dict_int | 1.0 | text search dictionary template for integers | Self-service |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings | Self-service |
| hstore | 1.8 | data type for storing sets of (key, value) pairs | Self-service |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers | Self-service |
| isn | 1.2 | data types for international product numbering standards | Self-service |
| lo | 1.1 | Large Object maintenance | Self-service |
| ltree | 1.3 | data type for hierarchical tree-like structures | Self-service |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams | Self-service |
| pgcrypto | 1.3 | cryptographic functions | Self-service |
| seg | 1.4 | data type for representing line segments or floating-point intervals | Self-service |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | Self-service |
| tcn | 1.0 | Triggered change notifications | Self-service |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | Self-service |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | Self-service |
| unaccent | 1.1 | text search dictionary that removes accents | Self-service |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | Self-service |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | Via ticket |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | Via ticket |
| orafce | 4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | Via ticket |
| pgaudit | 17.1 | provides auditing functionality | Via ticket |
| pljava | 1.6.10 | PL/Java procedural language | Via ticket |
| postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions | Via ticket |
| postgis_raster | 3.6.4 | PostGIS raster types and functions | Via ticket |
| postgis_sfcgal | 3.6.4 | PostGIS SFCGAL functions | Via ticket |
| postgis_tiger_geocoder | 3.6.4 | PostGIS tiger geocoder and reverse geocoder | Via ticket |
| postgis_topology | 3.6.4 | PostGIS topology spatial types and functions | Via ticket |
| vector | 0.8.7 | vector data type and ivfflat and hnsw access methods | Via ticket |
Available PostgreSQL Extension PostgreSQL 18
| Name | Version | Comment | Activation |
|---|---|---|---|
| btree_gin | 1.3 | support for indexing common datatypes in GIN | Self-service |
| btree_gist | 1.8 | support for indexing common datatypes in GiST | Self-service |
| citext | 1.8 | data type for case-insensitive character strings | Self-service |
| cube | 1.5 | data type for multidimensional cubes | Self-service |
| dict_int | 1.0 | text search dictionary template for integers | Self-service |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings | Self-service |
| hstore | 1.8 | data type for storing sets of (key, value) pairs | Self-service |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers | Self-service |
| isn | 1.3 | data types for international product numbering standards | Self-service |
| lo | 1.2 | Large Object maintenance | Self-service |
| ltree | 1.3 | data type for hierarchical tree-like structures | Self-service |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams | Self-service |
| pgcrypto | 1.4 | cryptographic functions | Self-service |
| seg | 1.4 | data type for representing line segments or floating-point intervals | Self-service |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | Self-service |
| tcn | 1.0 | Triggered change notifications | Self-service |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | Self-service |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | Self-service |
| unaccent | 1.1 | text search dictionary that removes accents | Self-service |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | Self-service |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | Via ticket |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | Via ticket |
| orafce | 4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | Via ticket |
| pgaudit | 18.0 | provides auditing functionality | Via ticket |
| postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions | Via ticket |
| postgis_raster | 3.6.4 | PostGIS raster types and functions | Via ticket |
| postgis_sfcgal | 3.6.4 | PostGIS SFCGAL functions | Via ticket |
| postgis_tiger_geocoder | 3.6.4 | PostGIS tiger geocoder and reverse geocoder | Via ticket |
| postgis_topology | 3.6.4 | PostGIS topology spatial types and functions | Via ticket |
| vector | 0.8.7 | vector data type and ivfflat and hnsw access methods | Via ticket |
Note on activating extensions:
- Extensions marked Self-service can be activated directly in your database with
CREATE EXTENSION <name>;.- Extensions marked Via ticket are activated for you by our support team. Please submit a support ticket.
postgis_raster,postgis_sfcgal,postgis_topologyandpostgis_tiger_geocoderrequirepostgis.postgis_tiger_geocoderadditionally requiresfuzzystrmatch.plpgsqlis installed by default in every database.
If you need a parameter that is not listed or want an extension activated, please submit a support ticket.