ST_BuildPyramid

Syntax

raster ST_BuildPyramid(raster source,
                       integer pyramidLevel default -1,
                       ResampleAlgorithm algorithm default 'Near',
                       cstring chunkTableName default '',
                       cstring storageOption default '{}',
                       cstring buildOption default '{}');

Parameters

Usage notes

• GPU acceleration: ST_BuildPyramid supports GPU-accelerated computing. In environments with active GPUs, Ganos enables GPU acceleration automatically.

• Parallel execution and transactions: If you run threads in parallel to create the pyramid, transactions are not supported. If pyramid building fails or you need to roll back, call ST_deletePyramid to remove the incomplete pyramid.

Examples

Example 1: Build a pyramid with default settings

DO $$
declare
    rast raster;
begin
    select raster_obj into rast from raster_table where id = 1;
    rast = st_buildpyramid(rast);
    update raster_table set raster_obj = rast where id = 1;
end;
$$ LANGUAGE 'plpgsql';

Example 2: Build a pyramid and store data in a specified chunk table

DO $$
declare
    rast raster;
begin
    select raster_obj into rast from raster_table where id = 1;
    rast = st_buildpyramid(rast, 'chunk_table');
    update raster_table set raster_obj = rast where id = 1;
end;
$$ LANGUAGE 'plpgsql';

What's next

• ST_deletePyramid: Delete a pyramid from a raster object.

• ganos.parallel.degree: Configure the default degree of parallelism for Ganos operations.