Konfiguration
10 Minuten Lesezeit
Die in der Tabelle aufgeführten Parameter stellen die spezifischen Konfigurationseinstellungen dar, die wir an die PostgreSQL-Standardkonfiguration anpassen. Diese Parameter sind auf die Anforderungen unserer Plattform zugeschnitten und werden sorgfältig ausgewählt, um Leistung und Zuverlässigkeit zu optimieren.
Hinweis: Die mit einem Sternchen (*) gekennzeichneten Parameter werden dynamisch auf Grundlage der verfügbaren Rechenressourcen berechnet, um eine nahtlose vertikale Skalierung zu ermöglichen.
Die in der Tabelle aufgeführten Parameter können Sie direkt im Cloudhub ändern.
| 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 |
Erläuterung der Tabelle
- Parameter: In dieser Spalte werden die Konfigurationsparameter aufgeführt.
- Type: Gibt den Datentyp des Konfigurationsparameters an (z. B. Integer, String).
- Default: Zeigt den Standardwert für jeden Parameter an.
- Modifiable: Zeigt an, ob der Parameter modifiziert werden kann (
true/false). - Restart Required: Gibt an, ob ein Neustart des Servers erforderlich ist, damit Änderungen wirksam werden (
true/false). - Min: Zeigt den minimal zulässigen Wert für numerische Parameter an.
- Max: Zeigt den maximal zulässigen Wert für numerische Parameter an.
- Allowed Values: Zeigt die zulässigen Werte für String-Parameter an.
Verfügbare PostgreSQL Extension PostgreSQL 14
| Name | Version | Comment | Aktivierung |
|---|---|---|---|
| btree_gin | 1.3 | support for indexing common datatypes in GIN | Selbstständig |
| btree_gist | 1.7 | support for indexing common datatypes in GiST | Selbstständig |
| citext | 1.6 | data type for case-insensitive character strings | Selbstständig |
| cube | 1.5 | data type for multidimensional cubes | Selbstständig |
| dict_int | 1.0 | text search dictionary template for integers | Selbstständig |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings | Selbstständig |
| hstore | 1.8 | data type for storing sets of (key, value) pairs | Selbstständig |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers | Selbstständig |
| isn | 1.2 | data types for international product numbering standards | Selbstständig |
| lo | 1.1 | Large Object maintenance | Selbstständig |
| ltree | 1.3 | data type for hierarchical tree-like structures | Selbstständig |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams | Selbstständig |
| pgcrypto | 1.3 | cryptographic functions | Selbstständig |
| seg | 1.4 | data type for representing line segments or floating-point intervals | Selbstständig |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | Selbstständig |
| tcn | 1.0 | Triggered change notifications | Selbstständig |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | Selbstständig |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | Selbstständig |
| unaccent | 1.1 | text search dictionary that removes accents | Selbstständig |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | Selbstständig |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | Per Ticket |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | Per Ticket |
| orafce | 4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | Per Ticket |
| pgaudit | 17.1 | provides auditing functionality | Per Ticket |
| pljava | 1.6.10 | PL/Java procedural language | Per Ticket |
| postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions | Per Ticket |
| postgis_raster | 3.6.4 | PostGIS raster types and functions | Per Ticket |
| postgis_sfcgal | 3.6.4 | PostGIS SFCGAL functions | Per Ticket |
| postgis_tiger_geocoder | 3.6.4 | PostGIS tiger geocoder and reverse geocoder | Per Ticket |
| postgis_topology | 3.6.4 | PostGIS topology spatial types and functions | Per Ticket |
| vector | 0.8.7 | vector data type and ivfflat and hnsw access methods | Per Ticket |
Verfügbare PostgreSQL Extension PostgreSQL 15
| Name | Version | Comment | Aktivierung |
|---|---|---|---|
| btree_gin | 1.3 | support for indexing common datatypes in GIN | Selbstständig |
| btree_gist | 1.7 | support for indexing common datatypes in GiST | Selbstständig |
| citext | 1.6 | data type for case-insensitive character strings | Selbstständig |
| cube | 1.5 | data type for multidimensional cubes | Selbstständig |
| dict_int | 1.0 | text search dictionary template for integers | Selbstständig |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings | Selbstständig |
| hstore | 1.8 | data type for storing sets of (key, value) pairs | Selbstständig |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers | Selbstständig |
| isn | 1.2 | data types for international product numbering standards | Selbstständig |
| lo | 1.1 | Large Object maintenance | Selbstständig |
| ltree | 1.3 | data type for hierarchical tree-like structures | Selbstständig |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams | Selbstständig |
| pgcrypto | 1.3 | cryptographic functions | Selbstständig |
| seg | 1.4 | data type for representing line segments or floating-point intervals | Selbstständig |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | Selbstständig |
| tcn | 1.0 | Triggered change notifications | Selbstständig |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | Selbstständig |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | Selbstständig |
| unaccent | 1.1 | text search dictionary that removes accents | Selbstständig |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | Selbstständig |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | Per Ticket |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | Per Ticket |
| orafce | 4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | Per Ticket |
| pgaudit | 17.1 | provides auditing functionality | Per Ticket |
| pljava | 1.6.10 | PL/Java procedural language | Per Ticket |
| postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions | Per Ticket |
| postgis_raster | 3.6.4 | PostGIS raster types and functions | Per Ticket |
| postgis_sfcgal | 3.6.4 | PostGIS SFCGAL functions | Per Ticket |
| postgis_tiger_geocoder | 3.6.4 | PostGIS tiger geocoder and reverse geocoder | Per Ticket |
| postgis_topology | 3.6.4 | PostGIS topology spatial types and functions | Per Ticket |
| vector | 0.8.7 | vector data type and ivfflat and hnsw access methods | Per Ticket |
Verfügbare PostgreSQL Extension PostgreSQL 16
| Name | Version | Comment | Aktivierung |
|---|---|---|---|
| btree_gin | 1.3 | support for indexing common datatypes in GIN | Selbstständig |
| btree_gist | 1.7 | support for indexing common datatypes in GiST | Selbstständig |
| citext | 1.6 | data type for case-insensitive character strings | Selbstständig |
| cube | 1.5 | data type for multidimensional cubes | Selbstständig |
| dict_int | 1.0 | text search dictionary template for integers | Selbstständig |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings | Selbstständig |
| hstore | 1.8 | data type for storing sets of (key, value) pairs | Selbstständig |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers | Selbstständig |
| isn | 1.2 | data types for international product numbering standards | Selbstständig |
| lo | 1.1 | Large Object maintenance | Selbstständig |
| ltree | 1.3 | data type for hierarchical tree-like structures | Selbstständig |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams | Selbstständig |
| pgcrypto | 1.3 | cryptographic functions | Selbstständig |
| seg | 1.4 | data type for representing line segments or floating-point intervals | Selbstständig |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | Selbstständig |
| tcn | 1.0 | Triggered change notifications | Selbstständig |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | Selbstständig |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | Selbstständig |
| unaccent | 1.1 | text search dictionary that removes accents | Selbstständig |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | Selbstständig |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | Per Ticket |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | Per Ticket |
| orafce | 4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | Per Ticket |
| pgaudit | 17.1 | provides auditing functionality | Per Ticket |
| pljava | 1.6.10 | PL/Java procedural language | Per Ticket |
| postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions | Per Ticket |
| postgis_raster | 3.6.4 | PostGIS raster types and functions | Per Ticket |
| postgis_sfcgal | 3.6.4 | PostGIS SFCGAL functions | Per Ticket |
| postgis_tiger_geocoder | 3.6.4 | PostGIS tiger geocoder and reverse geocoder | Per Ticket |
| postgis_topology | 3.6.4 | PostGIS topology spatial types and functions | Per Ticket |
| vector | 0.8.7 | vector data type and ivfflat and hnsw access methods | Per Ticket |
Verfügbare PostgreSQL Extension PostgreSQL 17
| Name | Version | Comment | Aktivierung |
|---|---|---|---|
| btree_gin | 1.3 | support for indexing common datatypes in GIN | Selbstständig |
| btree_gist | 1.7 | support for indexing common datatypes in GiST | Selbstständig |
| citext | 1.6 | data type for case-insensitive character strings | Selbstständig |
| cube | 1.5 | data type for multidimensional cubes | Selbstständig |
| dict_int | 1.0 | text search dictionary template for integers | Selbstständig |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings | Selbstständig |
| hstore | 1.8 | data type for storing sets of (key, value) pairs | Selbstständig |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers | Selbstständig |
| isn | 1.2 | data types for international product numbering standards | Selbstständig |
| lo | 1.1 | Large Object maintenance | Selbstständig |
| ltree | 1.3 | data type for hierarchical tree-like structures | Selbstständig |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams | Selbstständig |
| pgcrypto | 1.3 | cryptographic functions | Selbstständig |
| seg | 1.4 | data type for representing line segments or floating-point intervals | Selbstständig |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | Selbstständig |
| tcn | 1.0 | Triggered change notifications | Selbstständig |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | Selbstständig |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | Selbstständig |
| unaccent | 1.1 | text search dictionary that removes accents | Selbstständig |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | Selbstständig |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | Per Ticket |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | Per Ticket |
| orafce | 4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | Per Ticket |
| pgaudit | 17.1 | provides auditing functionality | Per Ticket |
| pljava | 1.6.10 | PL/Java procedural language | Per Ticket |
| postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions | Per Ticket |
| postgis_raster | 3.6.4 | PostGIS raster types and functions | Per Ticket |
| postgis_sfcgal | 3.6.4 | PostGIS SFCGAL functions | Per Ticket |
| postgis_tiger_geocoder | 3.6.4 | PostGIS tiger geocoder and reverse geocoder | Per Ticket |
| postgis_topology | 3.6.4 | PostGIS topology spatial types and functions | Per Ticket |
| vector | 0.8.7 | vector data type and ivfflat and hnsw access methods | Per Ticket |
Verfügbare PostgreSQL Extension PostgreSQL 18
| Name | Version | Comment | Aktivierung |
|---|---|---|---|
| btree_gin | 1.3 | support for indexing common datatypes in GIN | Selbstständig |
| btree_gist | 1.8 | support for indexing common datatypes in GiST | Selbstständig |
| citext | 1.8 | data type for case-insensitive character strings | Selbstständig |
| cube | 1.5 | data type for multidimensional cubes | Selbstständig |
| dict_int | 1.0 | text search dictionary template for integers | Selbstständig |
| fuzzystrmatch | 1.2 | determine similarities and distance between strings | Selbstständig |
| hstore | 1.8 | data type for storing sets of (key, value) pairs | Selbstständig |
| intarray | 1.5 | functions, operators, and index support for 1-D arrays of integers | Selbstständig |
| isn | 1.3 | data types for international product numbering standards | Selbstständig |
| lo | 1.2 | Large Object maintenance | Selbstständig |
| ltree | 1.3 | data type for hierarchical tree-like structures | Selbstständig |
| pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams | Selbstständig |
| pgcrypto | 1.4 | cryptographic functions | Selbstständig |
| seg | 1.4 | data type for representing line segments or floating-point intervals | Selbstständig |
| tablefunc | 1.0 | functions that manipulate whole tables, including crosstab | Selbstständig |
| tcn | 1.0 | Triggered change notifications | Selbstständig |
| tsm_system_rows | 1.0 | TABLESAMPLE method which accepts number of rows as a limit | Selbstständig |
| tsm_system_time | 1.0 | TABLESAMPLE method which accepts time in milliseconds as a limit | Selbstständig |
| unaccent | 1.1 | text search dictionary that removes accents | Selbstständig |
| uuid-ossp | 1.1 | generate universally unique identifiers (UUIDs) | Selbstständig |
| address_standardizer | 3.6.4 | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | Per Ticket |
| address_standardizer_data_us | 3.6.4 | Address Standardizer US dataset example | Per Ticket |
| orafce | 4.16 | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS | Per Ticket |
| pgaudit | 18.0 | provides auditing functionality | Per Ticket |
| postgis | 3.6.4 | PostGIS geometry and geography spatial types and functions | Per Ticket |
| postgis_raster | 3.6.4 | PostGIS raster types and functions | Per Ticket |
| postgis_sfcgal | 3.6.4 | PostGIS SFCGAL functions | Per Ticket |
| postgis_tiger_geocoder | 3.6.4 | PostGIS tiger geocoder and reverse geocoder | Per Ticket |
| postgis_topology | 3.6.4 | PostGIS topology spatial types and functions | Per Ticket |
| vector | 0.8.7 | vector data type and ivfflat and hnsw access methods | Per Ticket |
Hinweis zur Aktivierung von Extensions:
- Extensions mit dem Vermerk Selbstständig können Sie direkt in Ihrer Datenbank mit
CREATE EXTENSION <name>;aktivieren.- Extensions mit dem Vermerk Per Ticket werden von unserem Support für Sie aktiviert. Bitte eröffnen Sie dazu ein Ticket.
postgis_raster,postgis_sfcgal,postgis_topologyundpostgis_tiger_geocodersetzenpostgisvoraus.postgis_tiger_geocoderbenötigt zusätzlichfuzzystrmatch.plpgsqlist in jeder Datenbank standardmäßig installiert.
Falls Sie einen noch nicht aufgeführten Parameter benötigen oder eine Extension aktivieren lassen möchten, eröffnen Sie bitte ein Ticket.