Changes between Initial Version and Version 1 of UsersWikiPgRasterStorageModels


Ignore:
Timestamp:
Apr 13, 2009, 1:40:24 PM (15 years ago)
Author:
pierre
Comment:

—

Legend:

Unmodified
Added
Removed
Modified

  • UsersWikiPgRasterStorageModels

    v1 v1  
     1== Pg Raster Storage Models ==
     2
     3
     4
     5PGRaster is intended to store raster data within a PostgreSQL relational database that uses the PostGIS extensions.  The following are some possible storage models:
     6
     7 * LO - Use PostgreSQL large object to hold raster data.
     8
     9 * TOAST - Use PostgreSQL bytea data type to hold raster data
     10For each table that has a "toastable" data type, PostgreSQL automatically creates an associated toast table, which can hold large data value out-of-line from the main table.   PostgreSQL automatically manages toast tables, creating and destroying them as needed without any special effort by the table's user.
     11
     12 * Multitable - Define a set of canonical table structures that work together to store the raster data and its metadata.
     13The PGRaster type is used effectively as a key into the raster tables.  This approach is more along the lines of Oracle's SDO_RASTER data type.