On 11/5/18 8:50 AM, Charles Martin wrote:
Daniel said:
This appears to be the case. I ran:
SELECT max(length(docfilecontents::text)) FROM docfile;
and after a very long time, got:
ERROR: invalid memory alloc request size 1636085512 SQL state: XX000
Adrian said:
Ok, thanks for explaining this. Here is the current value:
"shared_buffers""131072""8kB"
>It should be a single value something like this for the default:
>shared_buffers = 128MB
The results I pasted were from:
SELECT * FROM pg_settings
Maybe I didn't get it the right way.
The system has only 4GB of RAM. I read that a reasonable swap size is
1/4 of RAM, so I've created a swap file of 1GB.
I would change the shared_buffers setting to 128MB and retry.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
