[postgis-users] Query crashes Postgres?

[Luca Bertoncello]

Am 27.01.2021 13:08, schrieb Giuseppe Broccolo:

> Yeah, I was pretty sure it was due to PostgreSQL trying to ask the OS
> for more resources than it was
> actually able to provide.

I use a PC with Debian 10 and Postgres from Repository.
The PC has 4 cores and 16 GB RAM.

> Yep, adding/increasing the SWAP is not elegant, because you are
> actually materialising the execution of the OS
> processes,but if this does the job you need to do...it's fine!

Unfortunately, I cannot add RAM right now...
So, SWAP is slow, but if it helps, then it's OK...

Ciao
Luca Bertoncello
(lucabert at lucabert.de)