We specified ”automatic” tiling which apparently amounted to no tiling. Tiling properly seems like a good approach, thank you.
Från: postgis-users <[email protected]> För Nicolas Ribot Skickat: den 5 september 2019 10:47 Till: PostGIS Users Discussion <[email protected]> Ä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>
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
