Postgreql/postgis : Error No space left on device SQL state: 53100

[celati Laurent]

 <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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20250624/026591b9/attachment.htm>