<https://gis.stackexchange.com/posts/494155/timeline>
Dear all, I want to compare a geoprocessing done in QGIS and PostGIS. It involves a union of two large polygonal vector layers.The processing in QGIS tooks 1.5 hours on a well-equipped workstation (32 GB of RAM). I was never able to complete the processing on PostGIS. Here is the tested SQL query: > create table public.union as select st_union(ST_Forece2D(mos.geom), > ST_Forece2D(bd_topo_bat.geom)) from public.mos, public.bd_topo_bat Here is the error message: > ERROR: could not extend file "base/19370/76968.57" with FileFallocate(): > No space left on device HINT: Check available disk space. ERROR: Could not > extend file "base/19370/76968.57" with FileFallocate(): No space left on > device SQL state: 53100 The error message is related to a problem with the temporary log file. In the postgresql.conf file, I edited the file by setting the value of log_temp_files = 10240. The default value was -1. I took this action based on this post: https://stackoverflow.com/questions/50833992/postgresql-no-space-left-on-device Thanks so much.
