PostGIS Tiles

implmature

Optimized vector tile generation using ST_AsMVT from PostGIS.

Scope

Enabling this extension might speed up vector tile generation for simple mappings (see limitations). The actual speedup depends on the resources available on the application and database servers, since part of the workload is shifted from the application to the database.

Limitations

Only simple value properties are supported. That means no objects, arrays, transformations or joins. Such properties may be excluded from the generated tiles, see option unsupportedProperties. The native CRS must not have a forced axis order.

Configuration

Options

Name	Default	Description	Type	Since
type		Always PGIS_TILES.	string	v2.0
enabled	false	Enable the extension?	boolean	v2.0
unsupportedProperties	DISABLE	How should the extension behave when unsupported properties are found in the configuration. Options are DISABLE to disable the extension, WARN to log a warning and IGNORE to ignore the properties.	string	v4.4

Example

- type: PGIS_TILES
  enabled: true
  unsupportedProperties: IGNORE