Postgres Pro
Downloads
Home   >   mailing lists

Re: Error: "could not fork new process for connection: Cannot allocate memory" - Mailing list pgsql-admin

From Fernando Hevia
Subject Re: Error: "could not fork new process for connection: Cannot allocate memory"
Date
Msg-id CAGYT1XTa-B=tzHoCBc2iO9_6vVTXXQtn-=dbiO-OMfzz1W8T1Q@mail.gmail.com
Whole thread Raw
In response to Re: Error: "could not fork new process for connection: Cannot allocate memory"  (frank picabia <fpicabia@gmail.com>)
List pgsql-admin
Tree view


El lun, 21 de dic. de 2020 a la(s) 10:25, frank picabia (fpicabia@gmail.com) escribió:

Here are settings as suggested in the wiki to run a query to
display those changed from defaults:

             name             |  current_setting  |        source        
------------------------------+-------------------+----------------------
 effective_cache_size         | 4TB               | configuration file


Probably unrelated to your error perse, but this setting doesn't seem sane on a 64 GB box... unless you have lots of swap on some remarkably fast storage.

Regards,
Fernando.


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Error: "could not fork new process for connection: Cannot allocate memory"
Next
From: frank picabia
Date:
Subject: Re: Error: "could not fork new process for connection: Cannot allocate memory"