[postgis-users] Query crashes Postgres?

[Luca Bertoncello]

Am 27.01.2021 10:10, schrieb Regina Obe:

Hi

> Would help if you can provide versions of things
> 
> SELECT postgis_full_version(), version();
> 
> To confirm you are running latest micro of everything.

POSTGIS="2.5.1 r17027" [EXTENSION] PGSQL="110" GEOS="3.7.1-CAPI-1.11.1 
27a5e771" PROJ="Rel. 5.2.0, September 15th, 2018" GDAL="GDAL 2.4.0, 
released 2018/12/14" LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.3.1" 
RASTER | PostgreSQL 11.9 (Debian 11.9-0+deb10u1) on x86_64-pc-linux-gnu, 
compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit

I think, it could be a memory problem, since if I start the query 
limiting the rows, it works...
The PC has 16GB RAM.

Thanks
Luca Bertoncello
(lucabert at lucabert.de)