[postgis-users] Query crashes Postgres?

Giuseppe Broccolo g.broccolo.7 at gmail.com
Wed Jan 27 04:08:48 PST 2021


Ciao Luca,

Il giorno mer 27 gen 2021 alle ore 11:15 Luca Bertoncello <
lucabert at lucabert.de> ha scritto:

>
> I tried now to add a SWAP file. I know, this is not the best, but right
> now I cannot add more RAM to the PC...
> It seems to help, since it runs and didn't crash yet...
>

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.

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!

Giuseppe.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20210127/4ae01635/attachment.html>


More information about the postgis-users mailing list