[postgis-users] Max size of rasters?

[Tobias Gerdin]

We specified ”automatic” tiling which apparently amounted to no tiling. Tiling properly seems like a good approach, thank you.

Från: postgis-users <postgis-users-bounces at lists.osgeo.org> För Nicolas Ribot
Skickat: den 5 september 2019 10:47
Till: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
Ämne: Re: [postgis-users] Max size of rasters?

Hello,

We are trying to create somewhat large rasters (30-40 bands of data comprising a few GB of data uncompressed). At some point the import into PostGIS is failing. Supposedly there is a 1GB field size limit in Postgres. Is it really so that you cannot have raster fields larger than 1GB? Seems like a pretty big limitation.

Warm regards,


Hi, Postgis raster (AFAIU), is meant to store rasters in small tiles, one tile per row, and not as a big object in one row.
What is the tile size you chose during the import ?

Postgis will be much more efficient when dealing with a raster table with a lot of small rows vs few big rows.

Nicolas
Havs- och vattenmyndigheten behandlar dina personuppgifter i enlighet med dataskyddsförordningen och myndighetens dataskyddspolicy, läs mer på www.havochvatten.se/sa-behandlar-hav-dina-personuppgifter<https://www.havochvatten.se/sa-behandlar-hav-dina-personuppgifter>
SwAM processes your personal data in accordance with the General Data Protection Regulation (GDPR) and our Data Protection Policy, see www.havochvatten.se/sa-behandlar-hav-dina-personuppgifter<https://www.havochvatten.se/sa-behandlar-hav-dina-personuppgifter>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190905/7e08881b/attachment.html>